We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Describe the bug
I'm trying to parse an ugly csv file, I got extra values on some records, here is an example :
Line 2 is failing because there is an extra value in this record. Expected 2 got 3
"name","address" "Bihl Christian","16","Rue De Kingersheim 68270 Wittenheim France" "Levy Guilene","1 Rue D Ottmarsheim 68170 Rixheim France"
{ "code": "CSV_RECORD_INCONSISTENT_COLUMNS", "message": "Invalid Record Length: columns length is 2, got 3 on line 200" }
To Reproduce
parse(csv, { columns: true, delimiter: [","], })
How can I clean ugly CSV file and success to parse this CSV by removing ugly data.
The text was updated successfully, but these errors were encountered:
Have you tried the relax_column_count option?
relax_column_count
Sorry, something went wrong.
No branches or pull requests
Describe the bug
I'm trying to parse an ugly csv file, I got extra values on some records, here is an example :
Line 2 is failing because there is an extra value in this record. Expected 2 got 3
To Reproduce
How can I clean ugly CSV file and success to parse this CSV by removing ugly data.
The text was updated successfully, but these errors were encountered: