Remving commas in my csv file

[andrew.haworth]

I am using automation to process fields in my CSV file into a Web form. This is working well and is 90% completed.

I have discovered an issue in my testing with additional commas included in my CSV file upon creation. The commas appear as detailed in my screenshot

I understand (from other forum posts), I can use a Regex replace function like:
System.text.RegularExpressions.Regex.Replace(YourString.ToString,“{2}”,“,”,.RegexOptions.Multiline)

My questions are should I perform this action as my file is being read or before that? I don’t wish to build a data table before these are cleared out right?!

My other question is I am having some trouble with the syntax validation ( to remove the commas) - I assume I use an assign command right?. Any help would be greatly appreciated?!

Thanks

Andrew

[postwick (Paul)]

Those aren’t extra commas. They’re blank columns. If you take them out, you’ll break the format of the CSV file.