Csv file has some special characters, so read csv is showing error as file format is invalid

Learning Hub Academy Feedback
1

csv file has some special characters, so read csv is showing error as file format is invalid

2

@Rachel Can you open the csv file manually?And what kind of Special Characters?

3

@supermanPunch thanks for the reply.

The data is

8521313_*02

4

@Rachel It Should have worked even with that data I suppose. Are you able to open the file manually?

5

yes i can open the file manually

But the read csv is showing this error “CSV file format is invalid”

6

@Rachel Is it possible to provide the file. I don’t think that’s a data problem.

7

@supermanPunch

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

1 Like
8

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