Using the Text.TrimEnd function without adding a new column?

[Flanner89]

I'm an M newbie and have been struggling with the most efficient way to solve a problem.  Three of the columns in a data source table have some values with an extra comma at the end.  For example, the "Product" column will have some records that say "Product A" and other records with "Product A," (notice the trailing comma). 

I see that the Text.TrimEnd function can help remove the extra comma.  For now, I'm creating a new column with the trimmed text using:

= Table.AddColumn(#"Changed Type", "Test", each Text.TrimEnd([Product],","))

This works. Is there any way to use that function without having to create a new custom column?  I'd like to just transform the values in the existing column.

[Anonymous · Accepted solution]

You could just delete the original column after creating your new one, then rename the new column - simple, but effective and readable.

Or if the commas ONLY appear at the end (e.g. "Fish, and Chips" can be changed to "Fish and Chips" try:

= Table.ReplaceValue(#"Changed Type", ",", "", Replacer.ReplaceText,{"Product"})

Alternately, try something arcane like below which ONLY removes one comma at the end:

= Table.TransformColumns(#"Changed Type", {{"Product", each if Text.EndsWith(_, ",") then Text.Start(_, Text.Length(_)-1) else _}})