I have a set of strings separated by commas in the following form:
"String1String","String2,String","String3String","String4,String",String5String,String6String
Some strings are enclosed in double quotes but not all. For example String5 and String6 in the example above are not enclosed in double quotes
Some strings themselves contain one comma within the string. These commas I wish to get rid of.
This occurs in String2 and String4.
How can I use a Find/Replace regular expression to get rid of the commas within the strings?
My best idea was to construct a regular expression as follows:
<double quote><0 or more chars><1 or more commas><0 or more chars><double quote>
The regular expression I came up with is ".*?,.*" or grouped "(.*)(?,)(.*)"
I cannot get this to work in UE when I test with Ctrl-F. Should this work? Is there a better idea?
Many thanks for any reply
"String1String","String2,String","String3String","String4,String",String5String,String6String
Some strings are enclosed in double quotes but not all. For example String5 and String6 in the example above are not enclosed in double quotes
Some strings themselves contain one comma within the string. These commas I wish to get rid of.
This occurs in String2 and String4.
How can I use a Find/Replace regular expression to get rid of the commas within the strings?
My best idea was to construct a regular expression as follows:
<double quote><0 or more chars><1 or more commas><0 or more chars><double quote>
The regular expression I came up with is ".*?,.*" or grouped "(.*)(?,)(.*)"
I cannot get this to work in UE when I test with Ctrl-F. Should this work? Is there a better idea?
Many thanks for any reply