Read CSV - adds quotes

[VanjaV]

Hi,

my original file (saved from xls as unicode text) looks like this:

after Read CSV (encoding utf-16, ignore qoutes = true) same file looks like this:

My question is, why does it sometimes add quotes and how to avoid it?

Thx for any suggestions.
Kind Regards,
Vanja

[Gokul001 (Gokul Balaji)]

Hi @VanjaV

Have a look on thread

How to remove Single quote(apostrophe) from excel

@RajeshT Are you converting the CSV file to Excel by Reading CSV File getting the Datatable and writing that Datatable to Excel File using Write Range Activity? If you are converting in that way, then After reading the Csv file, Change the Column Datatype to System.Double using the Change Column Datatype Activity. Then Write that Datatable to Excel using Write Range, The Green Color Quotes should be removed.

Regards
Gokul

[VanjaV]

Hi @Gokul001

link UiPath Marketplace | Error
returns error 404…