Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
C0D456942285d"Foo", "bar", "c", "1", 34, 56.63
foo, bar, "c, that was a delimiter back there" , 1, "56.633"
Got to love mixed content 😞
Sometimes I really wonder if a system generated it or someone was crazy enough to write it them selves and save it.
Lor-inc4561285dHonestly, this sounds entertaining. It can easily be parsed with a recursive function.
Plasticnova1951285dPretty gross, not impossible, but still gross
halfflat2055285dCSV is indeed flat; it's just that in this 'format', the flat data is itself a compressed representation of the data you really care about.
Not that that helps at all.
devasood2283dI have worked with a CSV, which has a free text column, which had such bad characters that they broke utf-8, ASCII and other encodings, had newline characters and all sorts of delimiters like tab, comma, semicolons, combinations of delimiters, non-breaking whitespace etc. It was not a double quoted column. So you could not read line and expect the entire row. You could not split by comma and get the columns. Splitting by comma could give you the number of columns you need, less than that or more than that depending on row. The free text field column data interchangibly had html, code in all different programming languages, comments. It was a stream of GitHub data