CSV to Datatable

Learning Hub Academy Feedback
1

Hi,

I am trying to convert a CSV into a data table. I am using the activity “Read Text File” and using “Generate Data Table” afterwards.

The problem is that the column separator “;” is not registered every time it occurs:

image
image1470×630 30.8 KB

Does anyone have a suggestion in how to make UiPath register every column seperator or even a better solution in converting the CSV into a data table?

2

Can you please share the text file ?
image

3

Did you try the ‘Read CSV’ activity?

4

RawData.xlsx (9.9 KB)

I tried uploading the CSV file, but i am not allowed to do so. So I have converted the file into excel

5

Hi Jacob,

“Read CSV” returns that the file type is invalid (Sytem.exeption)
But the file is still “.csv”

6

It seems like the “CSV Parsing” solved my problem. Thanks for taking the time assisting me. Much appreciated!

2 Likes
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.