Problem in reading csv

rpa_hackathon.zip (1.4 KB)
I have csv file. I am using read csv activity. It is a semi colon separated file. It has seven columns. But when i am using read csv and the output datatable of the this file says it has only one column. It is not able to recognise other columns.

Hi @Shashi123,

Yes,It would not be able to do so.
-Please convert text to columns on semicolon delimieter and then try to read the csv again.

Hi @Shashi123 Please check if Delimiter property of Read CSV activity is set to Semicolon. By default, it is set to Comma

image

1 Like