Field separator - boards

 

Import parameter to set the separator character for board records

 

The most common separator for data in an import file is comma ( , ) but in some cases it is not possible to use the comma and another symbol is used instead.

 

Enter the character or the ASCII number for the character for the separator to use (e.g. / or 47), for example:-

 

Field separator - boards: /

 

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 be used as a field separator.

 

For fractional numbers there may be two different separators: 21,1/2. In this example neither the comma ( , ) nor the forward oblique stroke ( / ) can be used as the field separator.

 

If the separator is other than comma ( , ) any commas 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

 

Note - values are ASCII decimal

 

See also