Using PapaParse transformHeader to remove whitespace from headers?

Question

If we have a CSV file like this:

`firstName, lastName
 Jim, Carrey
 Stephen, Colbert`

Papaparse will output the dynamically typed result like this:

       {firstName: 'Jim',
       ' lastName': '30000'}

In order to just get {firstName: 'Jim', lastName...} PapaParse 5.0.0 has a transformHeaders option, but there's no documentation on how to achieve this result yet.

Anyone have a transformHeader snippet that does this?

score 20 · Accepted Answer · answered Jun 06 '19 at 04:09

20

This ended up doing the trick:

const config = {
  delimiter: ",",
  header: true,
  dynamicTyping: true,
  transformHeader:function(h) {
    return h.trim();
  }
};

answered Jun 06 '19 at 04:09

Ole

41,793
59
191
359

1

I used this syntax instead: `transformHeader: ((header: string) => { return ... }` – Aaron Jordan Jan 13 '20 at 17:42
1

If you want to remove the space from something like `First Name` then you can use ```transformHeader:function(h) { return h.replace(/\s/g, ''); }``` – TwisterMc Oct 02 '20 at 18:42
```transformHeader: ((header: string) => header.trim())``` – kli Oct 04 '20 at 12:08

Using PapaParse transformHeader to remove whitespace from headers?

1 Answers1

Linked