What's the modern performant way to parse tab-tab-...
# cfml-general
d
What's the modern performant way to parse tab-tab-return data into an array of rows, each containing an array of column values. No quotes or funny chars involved, i.e., no tabs or returns within individual "cells" just straight up numbers, letters, hyphen, underscore, space. Old-school version is nested listToArray() calls. Is there a slicker and/or faster way?
t
a
NB: don't need the braces and the return if there's only a return value. So poss just:
Copy code
newData = data.listToArray(chr(10)).map((row) => row.listToArray(chr(9)))
👍 1
(also: be careful with the line endings... could be CRLF not just LF etc)
And... from a GDPR perspective... I hope those were not real ppl's details in that test data...
t
well with 7 billion of us I can't guarantee that but they came from a random data generator
😄 1