Forum Discussion
Solved
Replace or remove values that are not in specified format. (Find and keep values)
I am working with a bad quality dataset that has many annoying errors. Please help me with one that I haven't solved yet. There is two columns: SERIAL-NUMBER and DESCRIPTION - Serialnumber sho...
Thanks to all who answered!
In fact, I took a part from everybody's answer to build my own solution.
I created a new column where...
1...all acharacters but digits and used delimeters are removed.
2...text is splitted by any defined delimeter.
3...text is combined back with delimeter "-", but only if format is correct (4 digits + 4 digits)
Thanks to all who answered!
In fact, I took a part from everybody's answer to build my own solution.
I created a new column where...
1...all acharacters but digits and used delimeters are removed.
2...text is splitted by any defined delimeter.
3...text is combined back with delimeter "-", but only if format is correct (4 digits + 4 digits)