Read CSV file and put data in assign variable

RPA Discussions
1

Hey I am building a uipath process which reads csv files and puts the data into variables in uipath. This is an example csv file.
csv_datei_forum
This is how my process looks like:

uipath_ablauf
uipath_ablauf1570×993 63.8 KB

I dont understand why the Read CSV activity says that my Column(0) is 52 characters long.
Can you tell me what I am doing wrong?

Thanks in advance
uipathtest.zip (214 Bytes)

2

Hi,

Can you share your csv file, if possible?

Regards,

3

I think I cannot upload .csv files in this forum. Do you want a xls?

4

Hi,

I think csv is better. Can you compress it as zip format?

Regards,

5

Done
uipathtest.zip (214 Bytes)

6

can you do these 2 actions before read csv (back up uipathtest.csv first)

  1. read text file (uipathtest.csv) to string variable e.g. txt
  2. write txt.replace(chr(34), “”) to (uipathtest.csv)
    image
7

Hi,

it’s because comma is inside double quote and they are recognized as not separator but literal.

image
image799×109 3.7 KB

One of solutions is to remove double quote and parse it to csv using GenerateDataTable as the following.

image
image556×716 14.3 KB

Sample20220502-4.zip (2.6 KB)

Hope this help you.

Regards,