Parsing CSV content with Javascript

Question

I searched and tried many solutions including papa parser in angular and functions offered in the related Stackoverflow question...no luck. I always have a problem with fields which contain comma.

CSV file structure is like this: (export from Numbers)

name; address
Jack; 762 Texas Rd, Morganville NJ 07751 USA

...but I know that ";" or "," would have been a possible delimiter.

In papa, I tried to set delimiter '', so I expect papa parser to find the delimiter itself.

this.papa.parse(csv_content,{
      delimiter: '',
      complete: (result) => {
        if(result != undefined){
          console.log('Parsed: ', result);
        }
      }
    });

...It didn't papa parsed using ',' and not ';'. It couldn't detect ; as the delimiter.

If I convert all semi columns (;) into commas (,) and try to parse, than address field is splitted.

What is your suggestion?

Did you try setting `delimiter: ';'` explicitly? – Dhruv Murarka Dec 25 '18 at 12:17 — Dhruv Murarka, Dec 25 '18 at 12:17

score 0 · Answer 1 · answered Dec 25 '18 at 12:17

0

Set the delimiter explicitly instead of leaving it up to auto-detection.

const csv_content = `name; address
Jack; 762 Texas Rd, Morganville NJ 07751 USA`;

Papa.parse(csv_content, {
  delimiter: ';',
  complete: (result) => {
    if (result != undefined) {
      console.log('Parsed: ', JSON.stringify(result.data, null, 2));
    }
  }
});

<script src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/4.6.2/papaparse.min.js"></script>

answered Dec 25 '18 at 12:17

Quentin

857,932
118
1,152
1,264

Yes I can do this, but than I need to force visitors to upload only using ";" as delimiter. Some programs export using many different delimiters. – tolga Dec 25 '18 at 12:34

Parsing CSV content with Javascript

1 Answers1