CSV reader not understanding escape Character

[rds]

Hi ,

I am using CSV reader to read CSV but my one of the fields have Comma “,“ as part of the value.

I am using escape character “\“ , which means if name is (Jackson, Michael ) now it shows as (Jackson \, Michael) but still when i read the field , it is giving error - TOO many DATA ELEMENTS.

How can i make CSV reader treat comma as part of value and not as a delimiter

[ActionAndi]

Hi,

you can chance the decimal seperator in the “advanced settings” pane of the CSV reader.

Hope this helps
Andreas