Read text file into datatable

[Finken]

Hi,

I have a badly formatted .csv file, so I am not able to use read csv, read range (which requires .xls), etc. They all through exceptions when I try to read the file. But read text file works. But how could i get the string variable into a datatable?

The hole file seems to be one line, and the separator is “,”

Actually using Excel application scope and read range works. But the file contains some large numbers which UiPath does some formatting on, and which is not correct.

Read Range mess up numbers when read from file

Hi I have a quick question I hope someone can help me with. I am using Read Range to read a file into a DataTable. But when the file has been read into the DataTable it has “converted/changed format” on some of the numbers, as you can see below. For when I open the file manually in Excel, it has the correct number formatting, as you can see below. [number format] I need to keep the number format after I have read the file into a DataTable (or before i write it back to file), how can I achi…

[Dominic]

@finken, use generate data table activity and input your string then give comma as column separator and newline as row separator. Finally output it to your data table variable.

Let me know if you have any concern.

Regards,
Dominic

[Hassan_Ali]

After converting a text file into a datatable using Generate DataTable activity, please tell how can we access the entries of a particular column from this datatable?? Please reply as soon as possible!

Thanks in advance!