Forum Discussion
Replace Values
Hi all, I want to see if you guys have any feedback and help! So, I get data from a system that is fed manually, which means that I need to clean up the data before I can really work with it. Below...
Hi, KarlWat
Is it the steps above that bothers you? Why not try to replace "0VIN" with "VIN" like below:
#"Replaced Value" = Table.ReplaceValue(#"Merged Columns","VIN","/VIN",Replacer.ReplaceText,{"Merged"})Then, remove redundant prefixes as needed.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zeon,
Thanks for your answer. This definitely saves steps! I guess I didn't want to go this way because when splitting it leaves a blank row, which of course I can filter out, so actually this makes more sense.
However, I still don't know how to replace in bulk with not exact matches, so will leave this open and see if there is any other person with insight on this!
Thanks,