Data Items (Delimited)

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: 

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 reference 1 field

Related Articles:

Search related import documentation