Value in 1st Column:        

Function performed:

9001

Split at a specific character. Return the first part. By placing a 9001 in the field no column, the program will look to the start pos column for another number. That number must be an ASCII character number (32..126).  The importer will attempt to split the string being imported at the character specified.  The result will be the first half of the string.  The most common use of this conversion is when both street names appear in the same field as in "BROADWAY & MAIN ST."  Since the fields are combined there is no simple way to extract street 1 and street 2 individually.   Using 9001 in the field num. column and the ASCII number for & (38) in the start pos field, will result in retrieving BROADWAY from the first line and MAIN from the second.  The & character will be lost in this situation.  To extract street 2, use 9002. Note: if the character is not found, 9001 returns the entire string while 9002 returns a blank string.

9002

Split at a specific character. Return the last part. This function works exactly the same as 9001, except that it returns the second street.

9003

Return first token if it is a number, otherwise return blank. If the first word in the string is a number, it is returned as the value, otherwise a blank is returned.  Useful if the block number is attached to the street name.

9004

If first token is number, return all but first token. Same as 9003 except that instead of returning the number, the rest of the string is returned.

9005

Strip first token if it is N, S, E, W. As in the example above, if the first word in the string is one of (N, S, E, W) it is stripped off.

9006

Search for (number).  Return number, otherwise blank. Similar to 9003 except in addition to checking in the first word for a number, the importer also looks throughout the entire string for a '(number)'.  If such a sequence exists, the number in the parentheses is returned.  Otherwise a blank is returned.

9007

Strip either first token, or (number).  Whichever is first. Same as 9006 except that this function returns the rest of the string.  Note:  This function will not strip both the first word and the number in parenthesis, just the first which it comes upon.

9008

Multiply number by factor of 10. The value being imported is a number.  This function multiplies the number by a factor of 10.  Start Pos determines the factor.  (a 2 in the Start pos would multiply the imported number by 100)

9009

Divide number by factor of 10. Same as 9008 except the result is divided by a factor of ten instead of multiplied.

9010

Put extension on numbered street Looks at an imported street and if it is a number it will then add an extension based upon the number that is specified in the position field column.  1=Ave, 2=St, 3=Bl, 4=Cr, 5=Ln, 6=Dr, 7=Ct, 8=Hwy, 9=Frwy, 10=Pkwy, 11=Pl, 12=Rd, 13=Tpke, 14=Way.

9011

Strip matching first character. Looks at the value being imported.  If the first character matches the ascii code in the position field, then it will be removed.  Thus, the value "N1234" could be changed to "1234" by specifying: 9011  78  0 in the .IMP file. (The value 78 being the ASCII number for N.)

9012

Convert N, W, NW, SW to  negative sign. Looks at the second (the last) word in the imported string.   If that word can be converted to a number, then it looks at the first word in the imported string. If that word is N, W, NW, SW then the number is made negative and imported. Convert S, E, SE, NE to  positive sign. If that word is S, E, SE, NE, then the number is left positive and imported.   Otherwise the imported string is left as is.   This conversion is most often used to assign negative and positive numbers to hundred blocks.

9013

Strip all alpha characters. Removes all non-numeric characters from the string being imported.

9014

Adds a character to a field if the character is matched. Opposite of 9011, instead of removing the character, it will add it to the field being imported.  Handy if you don't want specific data to be converted in a .CNG file.

9015

Clear this field if character is >= desired.  Looks in the Start Pos field for an ASCII code.  Looks in the Count field for an index.  If the character at that index is >= to the ascii code specified, the field being imported is cleared.  Otherwise it returns the original value.

9016

Clear this field if character is <= desired.  Opposite of 9015.  Looks in the Start Pos field for an ASCII code.  Looks in the Count field for an index.  If the character at that index is <= to the ascii code specified, the field being imported is cleared.  Otherwise it returns the original value.

9017

Parses a VERY specific cross street format.  Used for CRAB data in Washington state.  Tokens are not case-sensitive. 1 distance string 2 direction string (+"after"/"before") 3 street name string If first token is 'at': - Distance & direction are empty - StreetName is remainder after 'at' ELSE if first token is a number: - if second token is 'mi' multiply distance (first token) by 5280 - direction is set to next token - Street name is set to what is left - if second token was not 'mi' or 'ft' then Distance, direction & street are all returned empty.