Extracting Beginning Characters

Problem: The account numbers of the Indiana_GL screen, which are in the first field of each line, include varying numbers of digits. However, the mapping associated with the file uses only four digits.

Solution: In the Import Scripts screen, assign the following script to the Expression field of the Account row. The script assigns the first four digits of each account number (the first four digits on the left) to Parse_Account:

def Parse_Account (strfield, strrecord):
		return strField[:4]	

Result: The import file displays only the first four digits of each account number.