words missing, JSON with special words like '#'

[yuqisha]

Hi, there are words missing with csv output converted by json2csv. I use the version 5.0.6. Below is my dataset, my code and the result of csv file.

code:

//dataset
const csvData = [ {
    "external_url": "2#",
  },
  {
    "external_url": "1#",
}]

function handleDownLoadCsv(csvData) {
  const fileParse = {
    fields:[{
        label: '落地页链接',
        value: 'external_url',
      }],
    widthBOM:true,
    excelStrings:true
  };
  try {
    const json2csvParser = new Parser(fileParse);
    const csvContent = 'data:text/csv;charset=GBK,\uFEFF' + csv;
    const encodedUri = encodeURI(csvContent);
  } catch (e) {
    console.log(e)
  }
}

csv result:

The JOSN content after the first '#' are all missing.

[knownasilya]

Can you paste the actual JSON output? Could be an issue with how you're rendering it

[juanjoDiaz]

const { Parser } = require("json2csv")

const csvData = [
  { "external_url": "2#" },
  { "external_url": "1#" },
];

const fileParse = {
  fields:[{
    label: '落地页链接',
    value: 'external_url',
  }],
  widthBOM:true,
  excelStrings:true
};

const json2csvParser = new Parser(fileParse);
const csv = json2csvParser.parse(csvData);
console.log(csv);

results in

"=""落地页链接"""
"=""2#"""
"=""1#"""

which is exactly as expected.

Not sure what are you doing to get that last item lost... 🤔

[juanjoDiaz]

Closing since the issue can't be replicated and there was no response