Thank you for looking at my question,
We have a csv file that contains report data. Each line of the csv file represents one line of the report with only a comma at the end. There are some commas in the reported text which throws the columnisation of the report out.
For each row in the csv file I need to delete the existing commas, find and replace double spaces " " with commas and then repeatedly find and replace all double commas ",," with single commas until there are no double commas left.
Any help you can offer will be appreciated