Forum Discussion
KarlWat
5 years agoFrequent Visitor
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...
HotChilli
5 years agoCommunity Champion
Can you post a data sample please?
- KarlWat5 years agoFrequent Visitor
Hi! So see attached:
https://docs.google.com/spreadsheets/d/1j5GRE9-P7Jq2aCRwTBbvgUeYlUrX8ZKdZsfXXbY-l7c/edit?usp=sharing
I tried posting the table here but it continued to mark it as error, then it wouldn't allow me to post then I forgot! anyway, what I do from source file is:
-Delete any spaces, and remove the "/" since I need to add it back in order to split the columns to have 1 number in each row, and sometimes the people who input the data won't add any "/" so the best I can do is have a string of numbers that go after the "VIN" letters, and the replace orders is basically running from 0 to 9 to add the "/" back so I can split columns.... any other way of doing it is appreciated!