Hi I have a problem with reading a csv file. I will attach a screenshot for you to see the structure of the file. I think somehow the problem is with the quotation marks. The read csv acivity properly reads only rows without quotation marks even though they are not doubled as you can see on a screenshot. I tried to solve this with first reading the file with read text file activity and then using regex to delete quotation marks but somehow regex also didnt work, it was deleting commas after quotation marks.
Thanks in advance for your help.
Hi @maciek
Kindly write csv and check whether it is working as expected or not instead of checking from watch or run time value. It might display different while checking from watch module - when you write the same in a different csv file - it should ideally match with your file.
kindly check and let me know
sample file is not a clear CSV structure (Worker: John XX Rows)
Quotation Mark we would handle at the settings:
and configure with false
Alternates (e.g. working on a cleanup text)
or Custom Parsing
Can you change extention before reading.
Convert cvs to xlsx. After try read.