Skip to content

Instantly share code, notes, and snippets.

@3leftturns

3leftturns/Address Parse

Created May 17, 2014 19:48
Show Gist options
  • Save 3leftturns/d44611d6329d6aa222a1 to your computer and use it in GitHub Desktop.
Save 3leftturns/d44611d6329d6aa222a1 to your computer and use it in GitHub Desktop.
Download ZIP
SQL select and parse address records from 1 column into 3: house number, cardinal direction, street address. Only works for fixed width addresses in format HHHH D AAAAAAAAAAAAAAAAAAAAA where H = house number, D = direction, and A = address. Address can be as long as needed.
Raw
Address Parse
SELECT SUBSTRING(address, 1, 4) AS houseNumber, SUBSTRING(address, 6, 2) AS cardinalDirection, SUBSTRING(address, 7, (LEN(address)-6)) AS streetAddress
FROM contactList
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment