Forum Discussion

KarlWat's avatar
KarlWat
Frequent Visitor
5 years ago

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...
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

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.