csv file has some special characters, so read csv is showing error as file format is invalid
@Rachel Can you open the csv file manually?And what kind of Special Characters?
@supermanPunch thanks for the reply.
The data is
@Rachel It Should have worked even with that data I suppose. Are you able to open the file manually?
yes i can open the file manually
But the read csv is showing this error “CSV file format is invalid”
@Rachel Is it possible to provide the file. I don’t think that’s a data problem.
Yes its a data problem
I have given the delimiter as “Pipe” in Read csv.
The data contains “|” character, Thats the issue.
I have removed the “|” character and its working fine now
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.