Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect parse row in CSV #1055

Open
FilippoSalvarani21 opened this issue May 23, 2024 · 1 comment
Open

Incorrect parse row in CSV #1055

FilippoSalvarani21 opened this issue May 23, 2024 · 1 comment

Comments

@FilippoSalvarani21
Copy link

I'm parsing a csv but during the loop the field is messed up after 539 rows. I think it could be some " character because some times they don't come in pairs due to errors in the source file.

I tried removing fast mode and specify the delimiter but without success:

const result = await fetch(Customers, {
headers: { "content-type": "text/csv;charset=UTF-8" },
});
const fileContent = await result.text();
let parsedCsvCstomers = Papa.parse(fileContent, {delimiter:"|", header: true, fastMode: false, skipEmptyLines: true})

Schermata 2024-05-23 alle 12 34 53 Schermata 2024-05-23 alle 12 35 29
@janisdd
Copy link
Contributor

janisdd commented Aug 28, 2024

Probably the same issue as in #1057
Try setting the quoteChar to something different than " (which is the default).
Quotes (the quoteChar) are used to quote the entire field, not just parts of it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants