Seperating A Address Field

[Kevin Roach]

Hello All!

Newbie to the forum!

I am using FM11, How can I separate out this address field? 2323 Lexington Avenue, Columbus, Ohio 43211

I need to have Street, City, State & Zipcode in separate fields. I have tried some calculations I found from various places but didn't work.

Thanks,

Kevin

[comment]

4 minutes ago, Kevin Roach said:

I need to have Street, City, State & Zipcode in separate fields

Street =

GetValue ( Substitute ( Address ; "," ; ¶ ) ; 1 )

Replace 1 with 2 and 3 to get the other two.