remove unnecessary comma in text/csv file using angular 2

Question

I want to remove unnecessary commas in file, with below code:

const data: any = utils.sheet_to_csv(ws);
let blob = new Blob(['\ufeff' + data], { type: 'text;charset=utf-8;' });
let dwldLink = document.createElement("a");
let url = URL.createObjectURL(blob);

I am getting below output from 1st line:

,,,,,       ,NTD00539,100000,01,Varsha,20180607

How to remove first 5 commas?

score 0 · Answer 1 · answered May 18 '18 at 20:55

0

You can remove the unneccessary ',' as shown below:

    while (data.match(/^,/) != null) {    
      data = data.replace(/^,/, ""); //replace  comma from firstplace    
    }

    while (data.match(/,\s*$/) != null) {    
       data = data.replace(/,\s*$/, ""); //replace  comma from lastplace    
    }

    while (data.match(/,,/g) != undefined) {    
      data = data.replace(/,,/g, ','); console.log('count')//replace  consecutive occurrence of comma 
    }

answered May 18 '18 at 20:55

Rak2018

935
6
16

where do i pest this code ? – Sagar Shedge May 21 '18 at 05:04
thanks but not working i try this.. some other solution....? – Sagar Shedge May 21 '18 at 12:02

remove unnecessary comma in text/csv file using angular 2

1 Answers1