如何使用JavaScript解析字段中包含换行符的CSV数据 [英] How to parse CSV data that contains newlines in field using JavaScript
问题描述
给定一个在某些字段中包含换行符/返回字符的CSV文件,我们如何解析数据而不将一个字段拆分成多行。
Given a CSV file that has newline/return characters in certain fields, how do we parse the data without splitting a field into multiple rows.
CSV数据示例:
ID;Name;Country;ISO-2;Address;Latitude;Longitude
022wje3;Europa;Italy;IT;"Viale Kennedy 3
34073 Grado";"45,67960";"13,40070"
024oua5;Hiberia;Italy;IT;"Via XXIV Maggio 8
00187 Rome";"41,89720";"12,48680"
028gupn;Regal Riverside;Hong Kong;HK;"34-36 Tai Chung Kiu Road
Shatin
Hong Kong";"22,38260";"114,19600"
02j7qry;Okaliptus Holiday Villas Apart;Turkey;TR;"Sevket Sabanci Caddesi No. 70
Bahçelievler Mevkii
Turgutreis";"37,02130";"27,25120"
02pc99z;California Apartementos;Spain;ES;"Prat d'en Carbó
43840 Salou";"41,07620";"1,14667"
02tu1jz;Elvis Presley's Heartbreak;United States;US;"3677 Elvis Presley Blvd.
Memphis
Tennessee 38116";"35,04850";"-90,02710"
注意:字段实际上用分号
;
分隔,因为地址可以包含逗号
Note: fields are actually separated by semicolon
;
because Address can contain commas
每行有7个字段,但我们不想错误地将包含换行符的字段中的数据解析为多行...
Each row has 7 fields but we don't want to mistakenly parse data in a field containing newline characters as multiple rows...
我们发现了一些专注于Perl的StackOverflow答案:
We found a few Perl-focussed answers on StackOverflow:
- How to parse CSVs with newline and commas inside a field in Perl?
- Text::CSV parsing when data contains newline
但是我对Perl有点生疏,还没有发现以JS为重点的答案。
but I'm a bit rusty on Perl and have not discovered a JS-focussed answer.
推荐答案
您是否尝试过 CSVToArray
?
Have you tried CSVToArray
by Ben Nadel?
/**
* CSVToArray parses any String of Data including '\r' '\n' characters,
* and returns an array with the rows of data.
* @param {String} CSV_string - the CSV string you need to parse
* @param {String} delimiter - the delimeter used to separate fields of data
* @returns {Array} rows - rows of CSV where first row are column headers
*/
function CSVToArray (CSV_string, delimiter) {
delimiter = (delimiter || ","); // user-supplied delimeter or default comma
var pattern = new RegExp( // regular expression to parse the CSV values.
( // Delimiters:
"(\\" + delimiter + "|\\r?\\n|\\r|^)" +
// Quoted fields.
"(?:\"([^\"]*(?:\"\"[^\"]*)*)\"|" +
// Standard fields.
"([^\"\\" + delimiter + "\\r\\n]*))"
), "gi"
);
var rows = [[]]; // array to hold our data. First row is column headers.
// array to hold our individual pattern matching groups:
var matches = false; // false if we don't find any matches
// Loop until we no longer find a regular expression match
while (matches = pattern.exec( CSV_string )) {
var matched_delimiter = matches[1]; // Get the matched delimiter
// Check if the delimiter has a length (and is not the start of string)
// and if it matches field delimiter. If not, it is a row delimiter.
if (matched_delimiter.length && matched_delimiter !== delimiter) {
// Since this is a new row of data, add an empty row to the array.
rows.push( [] );
}
var matched_value;
// Once we have eliminated the delimiter, check to see
// what kind of value was captured (quoted or unquoted):
if (matches[2]) { // found quoted value. unescape any double quotes.
matched_value = matches[2].replace(
new RegExp( "\"\"", "g" ), "\""
);
} else { // found a non-quoted value
matched_value = matches[3];
}
// Now that we have our value string, let's add
// it to the data array.
rows[rows.length - 1].push(matched_value);
}
return rows; // Return the parsed data Array
}
在您的情况下,使用以下命令调用它:
in your case invoke it with:
var rows = CSVToArray(CSV_string, ';');
其中 CSV_string
是您的CSV数据字符串。
where CSV_string
is your string of CSV data.
这篇关于如何使用JavaScript解析字段中包含换行符的CSV数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!