REGEX question

[way2many]

Hi,
I have comma delimited files where rows look like this:

"NN0K",22,33,"5,4",2006
"HHUN",35,50,"N80",2006

How can I substitute comma in string "5,4" for "5-4" ?

Thanks
P.S. I'm using C#

 

[ca8msm]

Use the Replace method


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[way2many]

Thank you for answering.

Would you be so kind to give me an example.

Please, note that I need to replace commas inside any fields with ""
So, this text file:

"NN0K",22,33,"5,4",2006
"H,KL,UN",35,50,"NFFS8,0FK",2006

should look like:

"NN0K",22,33,"5-4",2006
"H-KL-UN",35,50,"NFFS8-0FK",2006

 

[ca8msm]

Please, note that I need to replace commas inside any fields with ""

Ah, I see - your first post didn't say that. In that case you will need a Regular Expression.

I would suggest downloading "The Regulator" from

http://tools.osherove.com/CoolTools/Regulator/tabid/185/Default.aspx

as this will allow you to build and test your Regular Expressions.

Also,

http://regexlib.com/

is a good resource.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[way2many]

Thank so very much for the link!
I'll download "The Regulator".

So far I have found one solution which doesn't use regex and works for me:

http://www.csharpfriends.com/Forums/ShowPost.aspx?PostID=36497

string text1 = "\"This is, some text\", abc, def, \"How about, multiple, commas?\"";
string[] text2 = text1.Split(',');
string[] text3 = new string[text2.Length];
string[] text4 = null;
int i = 0;
bool inOpenQuote = false;

foreach (string text in text2)
{
if (inOpenQuote)
{
i--;
text3 = string.Concat(text3, ", ", text);
}
else
text3 = text;
i++;
if (text.Trim().StartsWith("\""))
{
inOpenQuote = true;
}
else if (text.Trim().EndsWith("\""))
{
inOpenQuote = false;
}

}

text4 = new string;
for (int index = 0; index < i; index++)
text4[index] = text3[index];

foreach (string text in text4)
MessageBox.Show (text)