Text.Remove with several characters

[P-Lag]

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

[johnt75 · Accepted solution]

You could try Text.Replace and use "" as the new text.

[v-jingzhang · Accepted solution]

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.

[Vijay_A_Verma]

Use this (No need to check for Text.Contains)

= Text.Remove([Equipment ID],Text.ToList("-1"))

[P-Lag]

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.

[wdx223_Daniel · Accepted solution]

try this

Text.Combine(Splitter.SplitTextByAnyDelimiters({"-1","S"})([EmployeeID]))

[johnt75 · Accepted solution]

You could try Text.Replace and use "" as the new text.

[P-Lag]

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. 

[v-jingzhang · Accepted solution]

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.

[johnt75]

I think you would need to add separate steps, one for each value you want to replace.