Data problem

  • Thread starter Thread starter Jason R. Melnyk
  • Start date Start date
J

Jason R. Melnyk

I have a vendor masterfile table. It has all the normal
stuff; name, address, city, state, etc.

The problem is the address field. There are two columns
that are address fields and those fields have additional
data besides pure address information. An example is:

Field 1 Field 2
11 Park Ave
Attn: Joe Smith 238 Bay Street
PO Box 1234
C/O Julie Smith 879 Maple Ct

The question is, how can I go about breaking out the pure
address data?

Thanks for any help in advance.
 
It may be that the sample data is not random enough but it looks like:

If [Field 2] Is Not Null
Use [Field 2]
Else
Use [Field 1]
End If
 
Back
Top