1. Learn
    2. /
  2. Courses
    3. /
  3. Exploratory Data Analysis in SQL

Exercise

Trimming

Some of the street values in evanston311 include house numbers with # or / in them. In addition, some street values end in a ..

Remove the house numbers, extra punctuation, and any spaces from the beginning and end of the street values as a first attempt at cleaning up the values.

Instructions

100 XP
  • Trim digits 0-9, #, /, ., and spaces from the beginning and end of street.
  • Select distinct original street value and the corrected street value.
  • Order the results by the original street value.