For the following data for a CSV file
1,'Tom'
10,'Mary'
Since there is a space before 1 and most CSV definitions note that any space is considered data and should not be striped, space then 1 will be converted to an atom and not an integer, i.e. ' 1'
However 10
does not have a space and will be converted to an integer.
Note: library(CSV) has option
strip(+Boolean)
Iftrue
(defaultfalse
), strip leading and trailing blank space. RFC4180 says that blank space is part of the data.