Is the first key of a csv table necessarily between quotes and therefore inaccessible?

Question

I have a react project with nodejs mongodb and I use csvparser to transform data from a csv table into data in my database, I noticed that the first key of my table is necessarily between coast for example :

fs.createReadStream(filePath)
    .pipe(csv({ separator: ';' })) 
    .on('data', (data) => {
      console.log(data)

Here's the answer :

{
  'Bookmaker': 'Unibet',
  Tipster: '',
  Sport: 'Football',
  Categorie: '',
  Competition: '',
  Type_de_pari: '',
  Pari_gratuit: '',
  Live: '',
  Type: 'Simple',
  Intitule_du_pari: 'Montpellier - Lille : Plus de 1,5 buts',
  Cote: '1.35',
  Mise: '50',
  Gain: '-50',
  Bonus_de_gain: '',
  Commission: '',
  Benefice: '-50',
  Etat: 'Perdu',
  Closing_Odds: '',
  Commentaire: ''
}

And from then on I can't access the bookmaker value because neither console.log(data.Bookmaker) nor console.log(data.['Bookmaker'] work. How can I retrieve the bookmaker values?

Answer 1

It looks like the data object you are getting from the csv-parser is using the first row as the header, and the keys of the object are defined based on the values in the first row. However, the keys seem to have leading or trailing spaces in their names, which is causing the issue when accessing them using dot notation.

To access the 'Bookmaker' value, you should use bracket notation, but you need to make sure to use the correct key name, considering the potential leading or trailing spaces. Here's how you can do it:

const dataRows = [];

fs.createReadStream(filePath)
  .pipe(csv({ separator: ';' })) 
  .on('data', (data) => {
    dataRows.push(data);
  })
  .on('end', () => {
    const sanitizedKeys = Object.keys(dataRows[0]).map((key) => key.trim());
    const bookmakerKey = sanitizedKeys.find((key) => key === 'Bookmaker');

    if (bookmakerKey) {
      dataRows.forEach((data) => {
        console.log(data[bookmakerKey]);
      });
    }
  });

By sanitizing the keys and then finding the correct key name, you can access the 'Bookmaker' value using bracket notation without any issues.