Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

  • No labels