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.

Questo esercizio fa parte del corso

Exploratory Data Analysis in SQL

Visualizza il corso

Istruzioni dell'esercizio

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.

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

SELECT distinct street,
       -- Trim off unwanted characters from street
       trim(___, ___) AS cleaned_street
  FROM evanston311
 ORDER BY ___;

Modifica ed esegui il codice