如何使用javascript计算*.CSV文件中每行的值数

how to count number of values for each row in *.CSV file using javascript?

本文关键字：文件 javascript 何使用 计算 CSV      更新时间：2023-09-26

我的csv数据看起来像这个

1,2,"hi,how ar you?",abc
3,5,a,b,c
expected output should be
4
5

'1,2,"hi,how ar you?",abc'.match(/"[^"]*"|[^,]+/g).length
4
'3,5,a,b,c'.match(/"[^"]*"|[^,]+/g).length
5

试试这个方法，它源自另一篇文章：

   var csvLines = '1,2,"how ar you?",abc' + "'n" + '1,4,"fine",6,7';
   var splitByChars = ',';
   var totalCount = 0;
   var linesArray = csvLines.split("'n");
   var lineCount = 0;
   while (lineCount < linesArray.length) {
       totalCount += StringCount(csvLines, splitByChars);
       lineCount++;
   }
   alert(totalCount);
   function StringCount(stringToSplit, splitBy) {
       var words = stringToSplit.split(splitBy);
       return words.length;
   }
相关文章：