mholt / PapaParse

Fast and powerful CSV (delimited text) parser that gracefully handles large files and malformed input
http://PapaParse.com
MIT License
12.47k stars 1.14k forks source link

Extra columns when parsing CSV rows with JSON object #1018

Closed ivasilov closed 1 year ago

ivasilov commented 1 year ago

When we try to parse input which has a JSON object in it, we're getting extra columns.

Example input:

reference,status,cargo
abc123,offline,[ { "age": 23, "name": "Jane" }, { "age": 25, "name": "John" } ]

Output:

[
  "abc123",
  "offline",
  '[ { "age": 23',
  ' "name": "Jane" }',
  ' { "age": 25',
  ' "name": "John" } ]'
]

We're using the library here

pokoli commented 1 year ago

Parsing of JSON is not supported. They are just considered as strings.