Forum Discussion
Solved
Replace spaces with an asterisk in Power Query
Hello, I am looking to find a way to find and replace spaces in a cell with an asterisk so that I can run the rest of the Power Query steps of my template. From the below image I am looking to add...
You can use the Table.ReplaceValue function. Replace #"Previous Step" with the Obvious
#"Remark Asterisk"=Table.ReplaceValue( #"Previous Step", each [Remarks 10], null, (x,y,z) as text=> if Text.StartsWith(y,"REMARK=") then Text.Replace(x," ","*") else x, {"Remarks 10"})
ronrsnfld
Super User
Super UserYou can use the Table.ReplaceValue function. Replace #"Previous Step" with the Obvious
#"Remark Asterisk"=Table.ReplaceValue(
#"Previous Step",
each [Remarks 10],
null,
(x,y,z) as text=> if Text.StartsWith(y,"REMARK=") then Text.Replace(x," ","*") else x,
{"Remarks 10"})
Thank you this worked perfectly!