Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

remove comma at the end of a string

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.

Need Help
Tips and Tricks
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    3 years ago

    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],",")," ",""),","," | ")

     

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    3 years ago

    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],",")," ",""),","," | ")

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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