Power Query Replacing more than one comma

[hatstand]

Hi All,

I have a file with varying amounts of words and commas in each row. To tidy things up and place one comma in front of every word (later to be split by delimiter). I am replacing every pair of commas with a single commas until the job is done. My problem is that it takes 20 lines as per below to get the job done. Is there a simpler method like a ",*". Obviously this won't work and I'm not up to speed with M code yet. Thanks for any pointers.

#"Replaced Value7" = Table.ReplaceValue(#"Replaced Value6",",,,,",",",Replacer.ReplaceText,{"Column1"}),

 

[Norie]

Here's the M code for adding the new column.

Table.AddColumn(#"Changed Type", "ReplaceMultipleDelimiters", each ReplaceMultipleDelimiters([Column1], ","))

You could try incorporating that into the M code for the query that's pulling in the data.

 

[hatstand]

No problem, I've changed it. Cheers.