Cleaning up STRINGS in BigQuery

Data is collected and processed in a number of ways, and it should come as no surprise that it's not always perfect. Perhaps the most important thing you need to do before analyzing data is have a look at how it's presented and check for irregulariti...