node-csvtojson icon indicating copy to clipboard operation
node-csvtojson copied to clipboard

csv read converting underscore ("_") in the column name to a hyphen ("-")

Open Nomercy10 opened this issue 6 years ago • 1 comments

I am reading a csv file using const jsonArray = CSV().fromFile(/tmp/${fileName}); There are column names like geotag_latitude & geotag_longitude, but after reading it the underscore in the column name is converted to a hyphen eg : geotag-latitude.

This is creating problems when I am trying to insert in a BigQuery table. Is there a solution for this? Am I doing something wrong?

Nomercy10 avatar Aug 28 '19 19:08 Nomercy10

this is odd..I cannot reproduce this. Could you please paste some sample data that has this issue?

Regards, Keyang

Keyang avatar Sep 10 '19 17:09 Keyang