Can't calculate because of the thousand seperators

• July 3, 2019 at 7:58 pm #25724
  
  pater

  Hi. I am using canvasjs to calculate the csv data and display them in a line chart. However, the line chart can’t display the calculation because of the thousand seperators in my csv file. If I remove those seperator in csv file column, the line chart works normal. So, what can I do? Thankyou.

  July 3, 2019 at 8:04 pm #25725
  
  pater

  thousand seperators are in points[2]
  I have tried to calculate points[1] and the chart works but not in points[3]

  function getDataPointsFromCSV(csv) {
    var dataPoints, csvLines, points;
    dataPoints = csvLines = points = [];
    
    csvLines = csv.split(/[\r?\n|\r|\n]+/);
    for (var i = 0; i < csvLines.length; i++)
      if (csvLines[i].length > 0) {
        points = csvLines[i].split(",");
        price = Math.log(points[3])

  • This reply was modified 5 years, 5 months ago by pater.
  July 4, 2019 at 7:15 pm #25738
  
  Manoj Mohan

  @pater,

  Can you kindly share sample project along with sample CSV over Google-Drive or Onedrive so that we can look into your code, understand the scenario better and help you out?

  —
  Manoj Mohan
  Team CanvasJS