I need solution for below question for CSV file

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



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



The following post may help you.