Separated Values Format

 Top  Previous  Next

In a Separated Values format-type file, the data fields are not in fixed position (in other words the text does not line up). Instead they are separated by a column separator, which may be a comma [ , ] or a pipe signal [ | ] or a full stop [ . ] or a TAB  or any other unusual character

 

 

Most files you import here will have the following fields:

 

•Item Code

 

•Quantity

 

•Cost Centre

 

 

 

The separator is placed after the last character in each field, for each item. The system will read field values as existing between the separators. Leading or trailing spaces are removed

Before importing, enter the following:

 

•Template: This is a name you give the settings below so that next time you import from the same source you do not have to re-enter the settings

 

 

•Header Lines: Type the number of lines you want the system to ignore when importing (they may include headings such as an address or title which you do not want to include in your bill).

 

•Strip Quotes: Some files will show quotation marks around items. Check this to remove quotation marks before importing.

 

•Separator: Enter the character that acts as separator in this file.