How to prevent ["A","B","C","D"] from being parsed into Import CSV?

[JoMar]

Hi,
I am trying to import a CSV (comma delimited, this cannot be changed from our DB) into EasyMorph.

The issue is that I have a field that has some double quotes and some commas that when I import, I always get it parsed. Is there a way of keeping it all in one field? This is a bit chaotic as I try to find the right wrap in double quotes in order not to parse it, but so far no success.

This if the format [“A”,“B”,“C”,“D”].

Thank you very much in advance.

[dgudkov]

You can do the following:

• Import the file as plain text first using the “Import plain text” action.
• Replace commas inside values with square brackets with something else (e.g. semicolons)
• Parse the text using the “Split delimited text into columns” action
• Replace semicolons back with commas