Snow throwing error while importing csv file which have " (double quote in one field value)

[Obito]

Hi all,

I am importing csv file and loading into snow but one field value is (15" OPEN). It is throwing error at the time of loading the error we are getting is [Expecting in position 174. Line="8","m03145","15" OPEN","56454453" ]

basically snow is expecting , (comma) after 15" . client wants the double quote after 15 . How to achieve that.

Note: due to size limitation we can not use excel format. we have to csv only

Thank you in advance 

[AnveshKumar M]

Hi @Obito 

To prevent this error the line in CSV should be like the one below.

8,m03145,"15"" OPEN",56454453

If you observe the error, there is no matching double quote, so it is throwing an error ("8","m03145","15" OPEN","56454453"). The one in the green color should have the matching " to prevent the error. Try with the line I posted above.

Please mark my answer helpful and accept as a solution if it helped 👍✔️