Hi!
I’d like to parse a CSV rows into typed elements, without knowing what is the schema (column order) of the CSV.
In ruby the CSV library will parse strings into types. In Elixir, both csv and nimble_csv libraries produce string values, and the caller is responsible for casting them into other types (integer, decimal, date-times).
For integer and decimal columns, I can detect if they contain just numbers and decimal point – with regexp or maybe binary matching?
For dates I have no idea how to proceed. I’m aware that date time format is not specified by rfc4180 – files I am parsing have dates in format: “2016-12-01 10:36:29.772554”.
What would you recommend? I am surprised this seemingly simple problem doesn’t have an obvious solution!
m.
