I need solution for below question for CSV file

[Vicky_K]

Hi All,

I receive data in CSV file format and i receive the data in below format,

In above screen shot xyz and abc column have numbers but it don’t have proper format.

I need in below format,

Note : I received in CSV file Format.

Please give me solution for above

Thanks in advance

Regards,
Vicky

[Anil_G (Anil Gorthi)]

@Vicky_K

Ideally if the file is read into datatable using read csv it should show the values as is only as in second screenshot unless the way it is saved itself is wrong

Also in excel depending on the column type and size of column the display values changes…it is only for display but in bavkend value would be same

Try to read into datatable and open dattable from locals panel and check the values…for locals panel to be visible add a breakpoint after reading and then run in debug mode

Cheers

[Yoichi]

Hi,

The following post may help you.

Csv Output Issue - Don’t want to round off value in CSV file

HI, From the image, the data is correctly stored in the CSV As i mentioned, it’s excel reading matter. It’s necessary to handle data as text in the sheet. For now, can you try to open the csv file via FIle-Open menu? Then Text Import Wizard will be launch, and set comma as demiliter and Text as dataformat? [image] Or write csv to excel using WriteRangeWorkbook, then check the xlsx file. [image] Regards,

Regards,