Page Comparison

...

Scripts are used when additional formatting is required on an import. You can use them to delete an extra line lines at the bottom of the import , or calculate 2 fields, combine fields etc

...

Standard script usage:

DeleteEmptyLines

Lines can be deleted with this. The import can stop on its own at the last line, but if a file contains empty lines among the data then that can cause errors for some fields such as dates.

Some lines that look empty can also simply be blank in excel, and these may also be wrongly imported. This can cause an import to be overly long and encounter issues as well.

This script checks if a line is empty in certain fields and deletes it if so. It only allows checking within the first 16 fields.

• Function: Checks specific fields (2 minimum) to see if they are empty and deletes the line. 

• Sequence: Not important.

• Script type: Before default.

• Field number: Not used.

• Parameter: Field;Field;... So for example if you want to delete lines where field 3, 5 and 6 are empty you would write this: 3;5;6

ReverseNumericValue

Used to convert positive amounts to negative, or negative amounts to positive.

• Function: Reverses the numeric value in a field.. 

• Sequence: Not important.

• Script type: Before default.

• Field number: Not used.

• Parameter: @field to be converted. So @5 to reverse the value in field 5.

...

Related articles

...