Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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],",")," ",""),","," | ")
@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
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],",")," ",""),","," | ")