marcin
How to parse CSV into typed terms?
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.
Marked As Solved
peerreynders
Am I missing something?
iex(1)> NaiveDateTime.from_iso8601("2016-12-01 10:36:29.772554")
{:ok, ~N[2016-12-01 10:36:29.772554]}
That date can then be “enhanced” with DateTime.from_naive/3.
Also Liked
LostKobrakai
Probably because it’s only “seemingly simple”. I can remember cursing at PHP’s strtotime a few times, because parsing dates without knowing the format is hardly more then guesswork and hoping for the best. If you know the format though you should be able to use timex to parse it.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"