I am getting error in read csv as invalid csv. Attached is my csv.abc.zip (8.6 KB)
Try to Use Read Text File Activity to read csv file
But how i count number of rows in read text file.
we refer your screenshot but we are geeting same error in read csv is invalid.
can you attach sample file for this.
Can you check if delimiter property in READ CSV activity is Tab?
Thanks a lot it works…cheers!! :grinning @Yoichi
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.
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 “,”.
Still we are not getting data in proper format. could you please attach sample file .
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.