Forum Discussion
Post PartisanRemoving certain characters
Hi, how can I remove certain charaters in Power Query. For example, below I want to remove the ":A:" so its just the numerical digits.
You can just select that column in the query editor, and click on Replace Values on the home tab. In the top box put :A: and leave the replace with box empty.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
3 Replies
- mahoneypat
Microsoft Employee
You can just select that column in the query editor, and click on Replace Values on the home tab. In the top box put :A: and leave the replace with box empty.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
PowerBI123456mahoneypat thank you!!!
rubinboerResolver II
is the string will remain :A: you can use SUBSTITUTE([column],":A:","") this will strip the ":A:" from your string