Forum Discussion

Bleucherie's avatar
Bleucherie
New Member
1 year ago
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...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    1 year ago

    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"})

     

ToddChitt's avatar
ToddChitt
Super User
1 year ago

You should be able to use the Power Query step of "Replace Values..." if you right click on the column.

 

 

You can't see it, but there is a space character in the Value to find field above.

Result: