Forum Discussion
Text.Remove with several characters
Hi!
Is it possible in some way to use Text.Remove with several characters?
This formula works when I add a new column, using one character in the text.remove:
if Text.Contains([Equipment ID],"-1") then
Text.Remove([Equipment ID],"-") else
[Equipment ID]
This is how I would like it to work, I want to remove the text "-1".
if Text.Contains([Equipment ID],"-1") then
Text.Remove([Equipment ID],"-1") else
[Equipment ID]
Thanks in advance.
Best regards, Pauline
You could try Text.Replace and use "" as the new text.
Hi P-Lag
You can nest multiple Text.Replace functions in one custom step. Text.Replace - PowerQuery M | Microsoft Learn
= Table.TransformColumns(#"previous step name", {{"Equipment ID", each Text.Replace(Text.Replace(_, "-1", ""), "S", "")}})
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.try this
Text.Combine(Splitter.SplitTextByAnyDelimiters({"-1","S"})([EmployeeID]))
7 Replies
You could try Text.Replace and use "" as the new text.
Hi johnt75
Thanks for the help, this worked! Just one more question. Is it possible to combine it with multiple argument? I would like to remove another value in the same expression but I don't success.
for example
replace "-1" and "S" with ""I have trided to add "and" function but do not sucess.
I think you would need to add separate steps, one for each value you want to replace.
Use this (No need to check for Text.Contains)
= Text.Remove([Equipment ID],Text.ToList("-1"))Hi
Vijay_A_Verma
Thanks for the tip to remove text.contains. Unfortunately this formula did not work, it removed all 1 and -1, so it removed more values than wanted.try this
Text.Combine(Splitter.SplitTextByAnyDelimiters({"-1","S"})([EmployeeID]))
