blocks|key|1294820|text|您可以在所有逗号上拆分，这些逗号后面有偶数的引号，使用下面的Regex查找它们：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1294821|",(?=(?:[%5E']*'[%5E']*')*[%5E']*$)"|code-block|syntax|javascript|1294822|你会用它就像|1294823|var+result+=+Regex.Split(samplestring,+",(?=(?:[%5E']*'[%5E']*')*[%5E']*$)");|1294824|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You could split on all commas, that do have an even number of quotes following them , using the following Regex to find them:

<pre><code>",(?=(?:[^']*'[^']*')*[^']*$)"
</code></pre>

You'd use it like

<pre><code>var result = Regex.Split(samplestring, ",(?=(?:[^']*'[^']*')*[^']*$)");
</code></pre>

blocks|key|2694025|text|//this+regular+expression+splits+string+on+the+separator+character+NOT+inside+double+quotes.+
//separatorChar+can+be+any+character+like+comma+or+semicolon+etc.+
//it+also+allows+single+quotes+inside+the+string+value:+e.g.+"Mike's+Kitchen","Jane's+Room"
Regex+regx+=+new+Regex(separatorChar+%2B+"(?=(?:[%5E\"]*\"[%5E\"]*\")*(?![%5E\"]*\"))");+
string[]+line+=+regx.Split(string+to+split);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2694026|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>//this regular expression splits string on the separator character NOT inside double quotes. 
//separatorChar can be any character like comma or semicolon etc. 
//it also allows single quotes inside the string value: e.g. "Mike's Kitchen","Jane's Room"
Regex regx = new Regex(separatorChar + "(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); 
string[] line = regx.Split(string to split);
</code></pre>

blocks|key|2650292|text|我遇到了一个问题，它没有捕获空列。我将其修改为获得空字符串结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2650293|var+results+=+Regex.Split(source,+"[,]{1}(?=(?:[%5E\"]*\"[%5E\"]*\")*(?![%5E\"]*\"))");|code-block|syntax|javascript|2650294|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I had a problem where it wasn't capturing empty columns. I modified it as such to get empty string results
<pre class="lang-cs prettyprint-override"><code>var results = Regex.Split(source, &quot;[,]{1}(?=(?:[^\&quot;]*\&quot;[^\&quot;]*\&quot;)*(?![^\&quot;]*\&quot;))&quot;);
</code></pre>

blocks|key|2693955|text|虽然有时候我也喜欢挑战，但这其实不是一个挑战。请阅读本文http://secretgeek.net/csv_trouble.asp，然后继续使用http://www.filehelpers.com/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2693956|Edit1，3，或者这篇文章也能帮上忙(链接只显示了一些VB.Net示例代码，但仍然可以与C#一起使用)：http://msdn.microsoft.com/en-us/library/cakac7e6.aspx！|style|BOLD|2693957|我试图为C#做这个示例(将对Microsoft.VisualBasic的引用添加到您的项目中)|2693958|using+System;
using+System.IO;
using+Microsoft.VisualBasic.FileIO;

namespace+ConsoleApplication1
{
++++class+Program
++++{
++++++++static+void+Main(string[]+args)
++++++++{
++++++++++++TextReader+reader+=+new+StringReader("('ABCDEFG',+123542,+'XYZ+99,9')");
++++++++++++TextFieldParser+fieldParser+=+new+TextFieldParser(reader);

++++++++++++fieldParser.TextFieldType+=+Microsoft.VisualBasic.FileIO.FieldType.Delimited;
++++++++++++fieldParser.SetDelimiters(",");

++++++++++++String[]+currentRow;+

++++++++++++while+(!fieldParser.EndOfData)
++++++++++++{
++++++++++++++++try
++++++++++++++++{
+++++++++++++++++++++currentRow+=+fieldParser.ReadFields();

+++++++++++++++++++++foreach(String+currentField+in+currentRow)
+++++++++++++++++++++{
++++++++++++++++++++++++Console.WriteLine(currentField);++++++++++++++++++++++++
+++++++++++++++++++++}
++++++++++++++++}
++++++++++++++++catch+(MalformedLineException+e)
++++++++++++++++{
++++++++++++++++++++Console.WriteLine("Line+{0}+is+not+valid+and+will+be+skipped.",+e);
+++++++++++++++}

++++++++++++}+

++++++++}
++++}
}|code-block|syntax|javascript|2693959|Edit2在这里发现了另一个有帮助的东西：http://www.codeproject.com/KB/database/CsvReader.aspx|2693960|-莱因哈德|2693961|entityMap|0|LINK|mutability|MUTABLE|url|http://secretgeek.net/csv_trouble.asp|1|http://www.filehelpers.com/|2|http://msdn.microsoft.com/en-us/library/cakac7e6.aspx|3|http://www.codeproject.com/KB/database/CsvReader.aspx^0|S|11|0|20|R|1|0|0|7|1H|1H|2|0|0|0|0|5|L|1H|3|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@$A|17|B|18|1|19]|$A|1A|B|1B|1|1C]]|C|$]]|$1|D|3|E|5|6|7|1D|8|@$A|1E|B|1F|F|G]]|9|@$A|1G|B|1H|1|1I]]|C|$]]|$1|H|3|I|5|6|7|1J|8|@]|9|@]|C|$]]|$1|J|3|K|5|L|7|1K|8|@]|9|@]|C|$M|N]]|$1|O|3|P|5|6|7|1L|8|@$A|1M|B|1N|F|G]]|9|@$A|1O|B|1P|1|1Q]]|C|$]]|$1|Q|3|R|5|6|7|1R|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1S|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]|12|$5|V|W|X|C|$Y|13]]|14|$5|V|W|X|C|$Y|15]]]]

although I too like a challenge some of the time, but this actually isn't one.
please read this article <a href="http://secretgeek.net/csv_trouble.asp" rel="noreferrer">http://secretgeek.net/csv_trouble.asp</a>
and then go on and use <a href="http://www.filehelpers.com/" rel="noreferrer">http://www.filehelpers.com/</a>

[Edit1, 3]:
or maybe this article can help too (the link only shows some VB.Net sample code but still, you can use it with C# too!): <a href="http://msdn.microsoft.com/en-us/library/cakac7e6.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/cakac7e6.aspx</a>

I've tried to do the sample for C# (add reference to Microsoft.VisualBasic to your project)

<pre><code>using System;
using System.IO;
using Microsoft.VisualBasic.FileIO;

namespace ConsoleApplication1
{
 class Program
 {
 static void Main(string[] args)
 {
 TextReader reader = new StringReader("('ABCDEFG', 123542, 'XYZ 99,9')");
 TextFieldParser fieldParser = new TextFieldParser(reader);

 fieldParser.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited;
 fieldParser.SetDelimiters(",");

 String[] currentRow; 

 while (!fieldParser.EndOfData)
 {
 try
 {
 currentRow = fieldParser.ReadFields();

 foreach(String currentField in currentRow)
 {
 Console.WriteLine(currentField); 
 }
 }
 catch (MalformedLineException e)
 {
 Console.WriteLine("Line {0} is not valid and will be skipped.", e);
 }

 } 

 }
 }
}
</code></pre>

[Edit2]:
found another one which could be of help here: <a href="http://www.codeproject.com/KB/database/CsvReader.aspx" rel="noreferrer">http://www.codeproject.com/KB/database/CsvReader.aspx</a>

-- reinhard

blocks|key|2650126|text|尝试(从Jens‘砍下)在拆分方法中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2650127|",(?:.*?'[%5E']*?')"|offset|length|style|CODE|2650128|或者在延斯的后面加上问号，这使它变得懒惰而不是贪婪。|2650129|entityMap^0|0|0|I|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Try (hacked from Jens') in the split method:

<code>",(?:.*?'[^']*?')"</code>

or just add question marks after Jens' *'s, that makes it lazy rather than greedy.

blocks|key|2694019|text|..。或者您可以安装NuGet包LumenWorks+CsvReader并执行如下操作，其中我读取了一个csv文件，其内容类似于|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2694020|"hello","how","hello,+how+are+you"
"hi","hello","greetings"
...|code-block|syntax|javascript|2694021|然后像这样处理|2694022|public+static+void+ProcessCsv()
++++++++{
++++++++++++var+filename+=+@"your_file_path\filename.csv";
++++++++++++DataTable+dt+=+new+DataTable("MyTable");

++++++++++++List<string>+product_codes+=+new+List<string>();
++++++++++++using+(CsvReader+csv+=+new+CsvReader(new+StreamReader(filename),+true))
++++++++++++{
++++++++++++++++int+fieldCount+=+csv.FieldCount;

++++++++++++++++string[]+headers+=+csv.GetFieldHeaders();
++++++++++++++++for+(int+i+=+0;+i+<+headers.Length;+i%2B%2B)
++++++++++++++++{
+++++++++++++++++++++dt.Columns.Add(headers[i],+typeof(string));
++++++++++++++++}

++++++++++++++++while+(csv.ReadNextRecord())
++++++++++++++++{
++++++++++++++++++++DataRow+dr+=+dt.NewRow();
++++++++++++++++++++for+(int+i+=+0;+i+<+fieldCount;+i%2B%2B)
++++++++++++++++++++{
++++++++++++++++++++++++product_codes.Add(csv[i]);
++++++++++++++++++++++++dr[i]+=+csv[i];
++++++++++++++++++++}
++++++++++++++++++++dt.Rows.Add(dr);
++++++++++++++++}
++++++++++++}
++++++++}|2694023|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

... or you could have installed NuGet package LumenWorks CsvReader and done something like below where I read a csv file which has content like for example

<pre><code>"hello","how","hello, how are you"
"hi","hello","greetings"
...
</code></pre>

and process it like this

<pre><code>public static void ProcessCsv()
 {
 var filename = @"your_file_path\filename.csv";
 DataTable dt = new DataTable("MyTable");

 List&lt;string&gt; product_codes = new List&lt;string&gt;();
 using (CsvReader csv = new CsvReader(new StreamReader(filename), true))
 {
 int fieldCount = csv.FieldCount;

 string[] headers = csv.GetFieldHeaders();
 for (int i = 0; i &lt; headers.Length; i++)
 {
 dt.Columns.Add(headers[i], typeof(string));
 }

 while (csv.ReadNextRecord())
 {
 DataRow dr = dt.NewRow();
 for (int i = 0; i &lt; fieldCount; i++)
 {
 product_codes.Add(csv[i]);
 dr[i] = csv[i];
 }
 dt.Rows.Add(dr);
 }
 }
 }
</code></pre>

blocks|key|1294903|text|接受的答案对我不起作用(可以在Regexr-+does上输入并测试，看它不起作用)。所以我不得不把这些线读成一系列的线条。使用(C#)+Regex.Matches获取转义引号之间的任何字符串数组(您的内字段逗号应该位于用引号包装的字段中)，并在将每行拆分为列/字段之前，将逗号替换为双逗号。在分割每一行之后，我将每一行和每一列循环起来，用逗号替换了{##**$}。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1294904|++++++++private+static+IEnumerable<string[]>+ReadCsv(string+fileName,+char+delimiter+=+';')
++++{
++++++++string[]+lines+=+File.ReadAllLines(fileName,+Encoding.ASCII);
++++++++//+Before+splitting+on+comma+for+a+field+array,+we+have+to+replace+commas+witin+the+fields
++++++++for(int+l+=+1;+l+<+lines.Length;+l%2B%2B)
++++++++{
++++++++++++//(\\")(.*?)(\\")
++++++++++++MatchCollection+regexGroup2+=+Regex.Matches(lines[l],+"(\\\")(.*?)(\\\")");
++++++++++++if+(regexGroup2.Count+>+0)
++++++++++++{
++++++++++++++++for+(int+g+=+0;+g+<+regexGroup2.Count;+g%2B%2B)
++++++++++++++++{
++++++++++++++++++++lines[l]+=+lines[l].Replace(regexGroup2[g].Value,+regexGroup2[g].Value.Replace(",",+"%7C%7C"));
++++++++++++++++}
++++++++++++}
++++++++}

++++++++//+Split
++++++++IEnumerable<string[]>+lines_split+=+lines.Select(a+=>+a.Split(delimiter));

++++++++//+Reapply+commas
++++++++foreach(string[]+row+in+lines_split)
++++++++{
++++++++++++for(int+c+=+0;+c+<+row.Length;+c%2B%2B)
++++++++++++{
++++++++++++++++row[c]+=+row[c].Replace("%7C%7C",+",");
++++++++++++}
++++++++}

++++++++return+(lines_split);
++++}|code-block|syntax|javascript|1294905|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The accepted answer does not work for me (can put in and test at Regexr-dot-com and see that does not work). So I had to read the lines into an array of lines. Use (C#) Regex.Matches to get an array of any strings found between escaped quotes (your in-field commas should be in fields wrapped in quotes), and replace commas with || before splitting each line into columns/fields. After splitting each line, I looped each line and column to replace || with commas.

<pre><code> private static IEnumerable&lt;string[]&gt; ReadCsv(string fileName, char delimiter = ';')
 {
 string[] lines = File.ReadAllLines(fileName, Encoding.ASCII);
 // Before splitting on comma for a field array, we have to replace commas witin the fields
 for(int l = 1; l &lt; lines.Length; l++)
 {
 //(\\")(.*?)(\\")
 MatchCollection regexGroup2 = Regex.Matches(lines[l], "(\\\")(.*?)(\\\")");
 if (regexGroup2.Count &gt; 0)
 {
 for (int g = 0; g &lt; regexGroup2.Count; g++)
 {
 lines[l] = lines[l].Replace(regexGroup2[g].Value, regexGroup2[g].Value.Replace(",", "||"));
 }
 }
 }

 // Split
 IEnumerable&lt;string[]&gt; lines_split = lines.Select(a =&gt; a.Split(delimiter));

 // Reapply commas
 foreach(string[] row in lines_split)
 {
 for(int c = 0; c &lt; row.Length; c++)
 {
 row[c] = row[c].Replace("||", ",");
 }
 }

 return (lines_split);
 }
</code></pre>

I got quite a lot of strings (segments of SQL code, actually) with the following format:

<pre><code>('ABCDEFG', 123542, 'XYZ 99,9')
</code></pre>

and i need to split this string, using C#, in order to get:

<ul>
<li>'ABCDEFG'</li>
<li>123542</li>
<li>'XYZ 99,9'</li>
</ul>

I was originally using a simple <code>Split(',')</code>, but since that comma inside the last parameter is causing havoc in the output i need to use Regex to get it. The problem is that i'm still quite noobish in regular expressions and i can't seem to crack the pattern mainly because inside that string both numerical and alpha-numerical parameters may exist at any time...

What could i use to split that string according to every comma outside the quotes?
Cheers

C# Regex Split - commas outside quotes

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我得到了相当多的字符串(实际上是SQL代码的片段)，格式如下：('ABCDEFG', 123542, 'XYZ 99,9')我需要使用C#拆分这个字符串，以便获得：'ABCDEFG'123542'XYZ 99,9'我最初使用的是一个简单的Split(',')，但是由于最后一个参数中的逗号正在对输出造成破坏，所以我需要使用Regex来获得它。问题是，在正则表达式中我仍然很幼稚，而且我似乎无法破解这个

问C# Regex拆分-逗号外部引号
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C# Regex拆分-逗号外部引号EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C# Regex拆分-逗号外部引号
EN