First page Back Continue Last page Image

Identifying White Space

Consider this query, we have replaced all spaces with asterisks so we can see them and count them and look for patterns

This query translates to: Find all the spaces in the field datastring and replace them with asterisks in the output

Also realize we did not change the data, we just changed what it looks like in the output

Now let’s apply this to our cleanup effort