REGEX TO FIX CRAPPY CHARS

ReadMe.md

REGEX TO FIX CRAPPY CHARS

1. Download a .CSV file from Data Management.
2. Open it in Sublime (or other text editor with a RegEx search).
3. Use the RegEx to search for "non-standard" characters.
4. Replace them with their HTML entity equivalent. (http://www.amp-what.com/)

Regex to Find Crap

[^0-9a-zA-Z\-\,\s\"\.\/\_\%\'\!\&\:\(\)\?\<\>\=\;\*\#\—\®\™\$\•\@\]\[\}\{\+]

Regex to Find Hidden Space

\xA0

or

\x0b