Import parameter to set the separator character for part records
The most common separator for data in an import file is a comma ( , ). In some cases however it is not possible to use the comma and another symbol is used instead.
- Enter the character or ASCII number of the separator to use, for example:-
The separator for fields must be different from the separator for decimal or fractional numbers. For example if a comma is used to separate decimals: 1200,0 it cannot also be sued as a field separator. For fractional numbers there may be two different separators: 21,1/2. In this case neither the comma ( , )or the oblique stroke ( / ) can be used as the part field separator. If the separator is other than a comma ( , ) any commas found are treated as decimal points in number fields. For example, if the separator is ( / ) the item (/1320,5/) is interpreted as the number 1320.5
Notes
ASCII codes
For the ASCII code enter a 2 digit code with a leading zero if necessary. Some common codes are:-
09 tab
35 # hash
36 $ dollar
37 % percent
38 & ampersand
42 * asterisk
44 , comma
45 - hyphen or dash
46 . period or dot
47 / forward oblique
58 : colon
59 ; semi colon
60 < less than
61 = equal
62 > greater than
63 ? question mark
64 @ commercial at
124 | vertical bar
The field separator can be any ASCII code between 32 and 127 except ", 0 to 9, A to Z or a to z. Values are the ASCII decimal values
Tab character
Tab is recognised as a separator for the following import formats
Part list order - ASCII/Unicode CSV (PNX)
Code and quantity - ASCII/Unicode CSV (PNX)
Batch - Part list order (BTX & PNX)
Batch - code and quantity (BTX & PNX)
User defined order - ASCII/Unicode CSV
Batch - user defined order (BTX)
