Data problem

[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.

 

[Van T. Dinh]

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