Hello all, Please can you assist with the following problem? I am trying to clean a large semi-structured dataset and I am on the cusp of solving this problem. Below is an example of the data that I need to clean by removing excessive delimiters (in this case commas) whilst maintaining at least one delimiter between variables. Dataline: 123456,,,,,,,,,,,,Test,,,,,,,,,,,,,,,,Delivery Assistant,,,,,,,,,,,,,,,01/0512016,,,,,,,,,,,,,2016-o5·01,,,,,,,,,,,,,Public Holiday,,,,,,,,,,,,,,,6.00,,,,,,,,,,,,,,,,,,,8:00,,,,,,,38.32,,,,,,,,,,,306.56,,,,,,,,,,,,,,,,,,,,,, Required output: 123456,Test,Delivery Assistant,01/0512016,2016-o5·01,Public Holiday,6.00,8:00,38.32,306.56 I have tried using substr, trim, compress however I have not been able to achieve the required output. Any assistance would be greatly appreciated.
... View more