RegEx to Clean Text
I used to work in Market Research and would spend hours cleaning up labels from surveys I’d programmed in online tools. The below video shows how easy it can be if you understand regular expressions and a little programming.
Regular Expressions can have a steep learning curve however it is really worth it if you continually get data that you need to clean. You can also check out this post of mine showing how they can be used to automate your metrics.