Address manipulation

Zoran
Date: 02/29/04 

Date: Sun, 29 Feb 2004 00:33:23 -0500

Hi all;

I have address in memo field. It is free text containing street (1, 2, or 3
lines), city, state, zip, and possibly telephone number or some other text.
City, state and zip could be all in the same line, or city and state could
be in the same line (zip in the next), or each of these 3 could be in
separate lines. I need to parse this memo text and get strings for:

street line#1
street line#2
street line#3
city
state
zip.

It's not a big deal, but it's time consuming. Does someone have the code (or
component) to do this?

Any help is appreciated.

Zoran

Relevant Pages

  • Re: Proper syntax for Is Null is Select Case
    ... > select * from tblCustomers where City is Null ... > allow zero length strings, ... > For me, as a developer, I want ONE thing that means a empty city field. ...
    (microsoft.public.access.forms)
  • Re: convert string into a variable object
    ... I would certainly use String for city names. ... A Hash seems like a good fit here. ... if he's not actually wanting to remove anything, I don't think Strings ... Is there something I'm missing? ...
    (comp.lang.ruby)
  • Re: Creating a CSV from query results
    ... If the data you are retrieving has embedded commas in ... them (i.e. City, State zip) the example will not produce a correct CSV file. ... At a minimum, strings should be enclosed in quotes, just to be safe. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: VLOOKUP
    ... "Lisa12" wrote in message ... same cell. ... Example City, State. ... How do I connect the two strings? ...
    (microsoft.public.excel.worksheet.functions)