正则表达式的问题（字符替换）

Question

现有文本如下"aa", "", "ccsadfd","东","dsjl"fghgfh"jkldsf;
"bb","繁大","sdf","1212","78455"sdfsdfsdf"的反抗;
如何把 类似"fghgfh"， "sdfsdfsdf" 这些字段里的里面的双引号去掉 fghgfh， sdfsdfsdf这些字符前面没有逗号，后面也没有逗号，怎样能够将他们的去掉？需要用到正则表达式吗,该怎么写呢？谢谢大家

Answer 1

不好意思,写错了
是这样的"aa", "", "ccsadfd","东","dsjl"fghgfh"jkldsf",
"bb","繁大","sdf","1212","78455"sdfsdfsdf"的反抗",
比如第一行，前面的几列都是用双引号和逗号分隔，最后一列，双引号里还套了一个双引号
"dsjl"fghgfh"jkldsf"
手工更改时，发现其中的规律时，双引号里套双引号时，里面的双引号前后都没有逗号所以怎样能把双引号前没有逗号，双引号后也没有逗号的，把这些双引号去掉----------------------------------------根据这个原则，就可以把 ,"dsjl"fghgfh"jkldsf", 里 第二个双引号，和第三个双引号去掉了
变成,"dsjlfghgfhjkldsf",即使这一列是  ,"dsjl"fgh"gf"h"jkl"ds"f",这样的,也可以根据规则，变成,"dsjlfghgfhjkldsf", 
---------------------------------
需要用到正则表达式吗,该怎么写呢？ 谢谢大家

Answer 2

using System;
using System.Text.RegularExpressions;class A
{
  static void Main()
  {
    string s = @"""aa"", """", ""ccsadfd"",""东"",""dsjl""fghgfh""jkldsf; 
""bb"",""繁大"",""sdf"",""1212"",""78455""sdfsdfsdf""的反抗;"; 
    string t = Regex.Replace(s, @"(?<!^|,\s*)""(?!\s*,|$)", "");
    Console.WriteLine(t);
  }
}
/* 程序输出：
"aa", "", "ccsadfd","东","dsjlfghgfhjkldsf; 
bb","繁大","sdf","1212","78455sdfsdfsdf的反抗;
*/

Answer 3

using System;
using System.Text.RegularExpressions;class A
{
  static void Main()
  {
    string s = @"""aa"", """", ""ccsadfd"",""东"",""dsjl""fghgfh""jkldsf"", 
""bb"",""繁大"",""sdf"",""1212"",""78455""sdfsdfsdf""的反抗"","; 
    Console.WriteLine("替换前:\n" + s);    string t = Regex.Replace(s, @"(?<!^|,\s*)""(?!\s*,|$)", "");
    Console.WriteLine("\n替换后:\n" + t);
  }
}
/* 程序输出：
替换前:
"aa", "", "ccsadfd","东","dsjl"fghgfh"jkldsf", 
"bb","繁大","sdf","1212","78455"sdfsdfsdf"的反抗",替换后:
"aa", "", "ccsadfd","东","dsjlfghgfhjkldsf", 
"bb","繁大","sdf","1212","78455sdfsdfsdf的反抗",
*/

Answer 4

谢谢wuyi8808 ，wanabe ，LemIST