breaking up a text field into an address

[hartmut]

Hello

I have a text file with addresses like below

PETERS NEW YORK PIZZERIA

144 STANDART AVE

Auburn, NY 13021 (315) 258-9488

I need to break the top line into the field

"company"

PETERS NEW YORK PIZZERIA

I need to break the Middle line into the field

"address"

144 STANDART AVE

I need to break the Bottom Line into the fields

"city" Auburn

"State" NY

"zip" 13021

"phone" (315) 258-9488

I need help on how to do this. I don't know how to manipulate text of find the second line or the last line

Can someone please show me how to do this?

Thanks

Dave :

[agtjazz]

I would recommend doing a search on the forums for address.... I remember a handful of topics asking what you are

From a quick search, here are two links

Link 1 and Link 2