For delimited files, data is referenced by the 1-based field index position.
Given the data:
CXT Software,3030 N. Central Ave.,Ste 708,Phoenix,AZ,85012,...
You would configure X Import as follows:
If the field value may contain the same character as your delimiter, the value must be surrounded with the Qualifier character (double-quote by default).
Fields may also be concatenated by separating the fields with a comma. Static text can be included by surrounding it with double-quotes.
Given the data:
1038,9784,CXT Software,...
X Import can be setup to include the Route and Stop IDs in the order's
Reference1 field:
Starting in X Dispatch 11.2.21, you can concatenate a comma into a concatenated string. This can be done using “,” or {COMMA} as the element to concatenate.
Given the date:
FirstName,LastName
Setting Referene1=2,”,”,1 or 2,{COMMA},1 will result in: “LastName, Firstname” in the refernece 1 field