Comments (2)
CSV data, by convention, omits quotes in the row "abc","xyz". In this case, the quotes serve a special purpose to bind all the characters between them together in one field. This is required when the data contains line breaks, quotes, or the delimiter character. With quoted fields, the encapsulating quotes are not actually part of the value/data.
You'd have to make the CSV file represent those quotes as part of the data:
"""abc""","""xyz"""
Three quotes are required because 1 quote encapsulates the field, then two are used to represent one in the data (that's how CSV escapes double-quote characters).
If you can't modify your CSV data, you can always iterate the results and append quotes to the beginning and end of each field after performing the parsing.
from papaparse.
Thanks a lot @mholt
from papaparse.
Related Issues (20)
- Feature Request: progress callback + complete callback with the bulk of the parsed entries
- Papa Unparse Delimiter and QuoteChar not working together HOT 1
- Preview of first row fails with "UndetectableDelimiter" error if file is too large HOT 1
- Parsing data with duplicate headers in streaming mode results in empty result HOT 1
- Extra columns when parsing CSV rows with JSON object HOT 1
- For CSV comma-delimited, when a row ends with an empty cell, papaparse mangles the next row's first cell HOT 1
- Autodetect of date formats
- renamedHeaders not showing in meta HOT 4
- Parse string with \n chars
- transformHeader called twice HOT 7
- nrows / skiprows HOT 1
- `Papa.parse()`: `comments` option breaks for quoted cells HOT 1
- JSON to CSV - LineBreaks in strings HOT 1
- Non-quote quoteChar still quotes quotes
- transformHeader for unparse? HOT 1
- Demo page appears to be failing with errors (large file, streaming and/or with headers)
- Do not discard embedded metadata stored in comments as per W3C recommendation
- Option to Disable Auto-Escaping During Parsing HOT 3
- skipFirstNLines is documented but not released HOT 4
- Parsing two-column csv with semi-column separator is not detected HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from papaparse.