Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6620 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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 :

This topic is 6620 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.