CSV Import

mg185225 · February 2, 2020, 9:48pm

Hi,

Trying to import a double-quoted qualified comma-separated CSV file and it doesn’t seem to handle commas within the lines.

e.g.
“123”,“Text”,“More Text”
“456”,“Text”,“More,Text”

Is imported as
Col1----Col2----Col3-------------Col4
123-----Text-----More Text
456-----Text ----More------------Text

I am setting setSeparator(’,’), but can’t seem to find a qualifier option?

ahsaniqbalsidiqui · February 3, 2020, 7:53am

@mg185225,
Please share your sample CSV and output file, and code snippet with us for our testing. We will reproduce the problem and provide our feedback after analysis. Please ZIP the files prior attaching.

mg185225 · February 3, 2020, 4:57pm

Issue appears to have been caused by extraneous double quote characters in the fields. I will strip them out using REPLACE or REGEX. Thank you for the quick response.

ahsaniqbalsidiqui · February 3, 2020, 5:00pm

@mg185225,
It seems that your issue is sorted out and feel free to contact us at any time if you need further help or have some other issue or queries, we will be happy to assist you soon.