Invalid csv

Help
, ,
1

I am getting error in read csv as invalid csv. Attached is my csv.abc.zip (8.6 KB)

2

Hi @Gauri_Rawool

Try to Use Read Text File Activity to read csv file

Regards,
Kommi Jeevan.

3

Thanks Kommijeevan :grinning:

4

But how i count number of rows in read text file.

5

Hi,

The following might help you.

img20191218-3
img20191218-31039×500 24.4 KB

Regards,

6

File.ReadLines(path).Count();

7

we refer your screenshot but we are geeting same error in read csv is invalid.

8

can you attach sample file for this.

9

Hi,

Can you check if delimiter property in READ CSV activity is Tab?

Regards,

10

Thanks a lot it works…cheers!! :smile: :grinning @Yoichi

1 Like
11

we read the csv file and replace also “~” to ",’ but when we are converting it to .xlsx it is not giving proper data in excel.abc.zip (24.5 KB)

attached is the csv and converted excel.

12

Hi,

In this case “,” is not good because some data contains “,” and parser identify it as a separator.
So perhaps you should use “;” or Tab like above post instead of “,”.

Regards,

13

Still we are not getting data in proper format. could you please attach sample file .

14

Hi,

How did you create the excel file?
You can create it to put Write Range activity after Read CSV activity in my previous post, as the following.

img20191218-4

Regards,

15

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