How to specify different datatypes in CSV files

To specify various datatypes in a CSV file, use the following rules:

1 If the value is alphabetic or begins with a single quote ('), it is a string and the first apostrophe is stripped. For example, the following are all strings:

abc

'abc (becomes abc)

'123 (becomes 123)

''123 (becomes '123)

2 If the input is recognized as numeric, the datatype is a Double. For example, the following are all converted to Doubles

100.00

-100.00

-1

3 The following are all recognized as Boolean values:

True

TRUE

tRue

FALSE

false

4 Anything that is not covered above is considered a String.