Parse usable Street Address, City, State, Zip from a string [closed]

by

I’ve done a lot of work on this kind of parsing. Because there are errors you won’t get 100% accuracy, but there are a few things you can do to get most of the way there, and then do a visual BS test. Here’s the general way to go about it. It’s not code, because it’s pretty academic to write it, there’s no weirdness, just lots of string handling.

(Now that you’ve posted some sample data, I’ve made some minor changes)

  1. Work backward. Start from the zip code, which will be near the end, and in one of two known formats: XXXXX or XXXXX-XXXX. If this doesn’t appear, you can assume you’re in the city, state portion, below.
  2. The next thing, before the zip, is going to be the state, and it’ll be either in a two-letter format, or as words. You know what these will be, too — there’s only 50 of them. Also, you could soundex the words to help compensate for spelling errors.
  3. before that is the city, and it’s probably on the same line as the state. You could use a zip-code database to check the city and state based on the zip, or at least use it as a BS detector.
  4. The street address will generally be one or two lines. The second line will generally be the suite number if there is one, but it could also be a PO box.
  5. It’s going to be near-impossible to detect a name on the first or second line, though if it’s not prefixed with a number (or if it’s prefixed with an “attn:” or “attention to:” it could give you a hint as to whether it’s a name or an address line.

I hope this helps somewhat.

More Related Contents:

  1. Reading a file line by line in Go
  2. How do I parse a string into a number with Dart?
  3. Groovy String to Date
  4. Can I convert a string to enum without macros in Rust?
  5. How to compare strings in Bash
  6. How do I parse a string with a decimal point to a double?
  7. Create variables with names from strings
  8. Get string after character [duplicate]
  9. How do I concatenate strings?
  10. How can I convert a string to upper- or lower-case with XSLT?
  11. Load R package from character string
  12. Repeat string to certain length
  13. Algorithm to convert an IEEE 754 double to a string?
  14. Multi-line string with extra space (preserved indentation)
  15. Replace whole line containing a string using Sed
  16. How can I compare a string to multiple correct values in Bash?
  17. Count word occurrences in R
  18. converting datetime string to POSIXct date/time format in R
  19. Python: most idiomatic way to convert None to empty string?
  20. Extract numeric part of strings of mixed numbers and characters in R
  21. Use character string as function argument
  22. Integer PadLeft function in T-SQL
  23. When using the MOV mnemonic to load/copy a string to a memory register in MASM, are the characters stored in reverse order?
  24. Convert specified column in a multi-line string into single comma-separated line
  25. Convert time.Time to string
  26. How to join multiple lines of filenames into one with custom delimiter
  27. Find all words with 3 letters with regex
  28. Excel VBA like operator [closed]
  29. Swift – Split string over multiple lines
  30. What is the difference between VBScript’s + and & operator?

Leave a Comment