Parse Address Field

[Lisa W.]

I am trying to create an Address Line 2 field; I need to parse the data after
the comma in example #1 and if there is an address with no comma, I would
like that field to be blank. The address information either has a comman
separating the 2nd part of the address or it simply appears with the street
number and name.

Example #1: 5 Executive Campus, Suite 100

Example #2: 3280 Northway Drive

Address Line 2 would look like: Suite 100 (example 1) or "blank" field
(example #2)

Any assistance is greatly appreciated.

Thanks,
Lisa W.

 

[KARL DEWEY]

Try this --
Line1: IIF(Instr([Address],",")<1, [Address], Left([Address],
Instr([Address],",")-1)
Line2: IIF(Instr([Address],",")<1, Mid([Address], Instr([Address],",")+1))