>I have an address field that is in the format "MAITLAND FL 32751-4831". I also have an a_states array for each of the 50 states. What is an efficient way to parse the address into tcity, tstate, tzip?
>
>Thanks
>
>Brenda
How about something like
lnWordCount = GETWORDCOUNT(lcAddress)
tzip = GETWORDNUM(lcAddress,lnWordCount)
tstate = GETWORDNUM(lcAddress,lnWordCount-1)
tcity = ""
FOR I = 1 TO lnWordCount -2
tcity = tcity + " " + GETWORDNUM(lcAddress,I)
ENDFOR
tcity = SUBSTR(tcity,2)