如何解析带有引号但没有换行符的csv文件?
问题描述：
如何使用C#解析这样的csv文件?
How can I use C# to parse a csv file like this?
"TeamName","PlayerName","Position" "Chargers","Philip Rivers","QB" "Colts","Peyton Manning","QB" "Patriots","Tom Brady","QB"
请注意，自然换行符为零.值之外的双精度空格将一行与另一行区分开.
Notice that there are zero natural line breaks. Double-spaces that reside outside of the values are what differentiate one row from another.
相关:
- line breaks lost in sql server
- How do you view ALL text from an ntext or nvarchar(max) in SSMS?
答
您可以尝试以下方法.
var content = File.ReadAllText(@"path/to/csv").Replace(" ", ";");
var result = content.Split(';');
foreach (var str in result)
{
Console.WriteLine(str);
}