marcelo507

Nevermind… my bad.

I forgot to include the header with the fields names in my CSV.

rgds,
Marcelo

Hi macguru2000,

I ended up working around the escaping character issue by adding a single ” after all fields/columns that needed double quotes. If you do that excel will the double quote that field when it generates the CSV.

Then I opened the CSV with Notepad and replaced all “”” with “.

Not ideal but worked. Thanks a lot for your awesome support!

I have one more question but I will open a new topic since it’s not related to this one.

Marcelo

Hi macguru2000,

Thanks a lot for the fast reply!

About #1: I am going to do some more testing and let you know.

#2 and #3: It worked perfectly after I fixed the CSV file to have quotes in some field like in your example file. Do you know if there is a way to generate these quotes from Excel?

#4: Cool, thanks.

I will let you know what I find out with #1.

Thanks once again!

Marcelo