Deal with CSV format variations

[nhoizey]

For example, a CSV exported from a Google Analytics report starts like this:

# ----------------------------------------
# nicolas-hoizey.com
# Viewport et densité d'écran
# 20180501-20180731
# ----------------------------------------

Viewport width,Screen density,Pageviews
1920,1,"3,505"
1440,2,"1,341"
1366,1,"1,194"
375,2,725
360,3,587

• ; separator
• comment lines
• empty lines
• delimiter (")
• thousands separator (",")
• decimal separator ("." in English, "," in French)

[ryuran]

Some of this are parser’s options https://csv.js.org/parse/options/

parameters	parser’s option
“separator”	delimiter
“comment lines”	comment
“empty lines”	skip_empty_lines
“delimiter”	quote