remove comma at the end of a string

[Anonymous]

Hi,

A bit new to power query and I cant seem to find a soultion for puting a pipiline between words and removing the comma at the end of a string ex. AAA, BBB, needs to transform to AAA | BBB

Any help or guidance appreciated.

Thanks.

[Anonymous]

@Vijay_A_Verma thanks.

Is the approache the same for a column that is AAA, BBB, CCC, ? I cant seem to get it working.

Br.

Rado

[Vijay_A_Verma · Accepted solution]

You can use this where Data is column name

= Text.Replace(Text.TrimEnd([Data],","),","," |")
\\ A more robust formula would be
Text.Replace(Text.Replace(Text.TrimEnd([Data],",")," ",""),","," | ")