Forum Discussion
Delete Words from Row
In PQ you can use this code
#"Changed Type" = Table.TransformColumnTypes(Facts44_Table,{{"User", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","user1","",Replacer.ReplaceText,{"User"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","user2","",Replacer.ReplaceText,{"User"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1",",","",Replacer.ReplaceText,{"User"}),
#"Trimmed Text" = Table.TransformColumns(#"Replaced Value2",{{"User", Text.Trim, type text}})
in
#"Trimmed Text"If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In PQ you can use this code
#"Changed Type" = Table.TransformColumnTypes(Facts44_Table,{{"User", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","user1","",Replacer.ReplaceText,{"User"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","user2","",Replacer.ReplaceText,{"User"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1",",","",Replacer.ReplaceText,{"User"}),
#"Trimmed Text" = Table.TransformColumns(#"Replaced Value2",{{"User", Text.Trim, type text}})
in
#"Trimmed Text"
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello mangaus1111 ,
Thank you! I was able to do this - only alteration was adding a space before and after the comma.