Option at Quote import dialog to choose the character between fields
This is the character used in the import files to separate one field from another.
Import file
DRESSER,2,Dressing table,Urgent,Line AS,1000.0,1100.0,600
WARDROBE,7,Wardrobe - drawer & door,Urgent, Line AP,1000.0,1800.0,600.0
BATHROOM-CABINET,4,Bathroom cabinet,Priority,Line AS,700.0,600.0,180.0
The most common separator for data in an import file is a comma ( , ). In some cases however it is not possible to use comma and another symbol is used instead.
- Enter the character or ASCII number for the character of the separator to use e.g. 44 or , (comma)
Notes
- 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 used 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 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
- For the ASCII code enter a 2 digit code with a leading zero if necessary. Some common codes are:-
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
62 > greater than
63 ? question mark
64 @ commercial at
Values above are the ASCII decimal values
