I have a field: INPUT, and fields for Property Name, Address, City, State, Zip and Phone.

I'm trying to parse this standard format for each record into the fields above:

Complex Name: Property ABC

Complex Address: 123 Main Street

Complex City, State Zip: Miami, FL 12345

Complex Phone: 123-456-7891

If it matters, some of the phone numbers have extensions added as well.

Also, when I paste this section into a field, the paste shows up like this:

Complex Name:

Property ABC

Complex Address:

123 Main Street

etc.

It basically has a carriage return, and then 1 tab over to the info.

Any advice would be greatly apprecaited... Thanks!

See something quite similar here:

http://fmforums.com/forum/topic/79176-parse-email-data-into-multiple-fields/page__p__369332#entry369332

See something quite similar here:

http://fmforums.com/...332#entry369332

That works great for the Name, Address, Phone fields, but I'm not sure how to parse the data in the City State Zip field. I'd like it to some how say "the city field prefix is Complex City, State Zip:, but before the comma is the City, After the 2 letter code after the comma is the state, and the last part which is 5 numbers is the zip.

Any idea on how to do that?

Thank you, you are a great help.

I may have done it before, less the zip code, I just can't figure it out...

Well, for the City the start point is the position of the complex prefix + its length, while the end point is the first comma after that, i.e.

end = Position ( RawText ; "," ; start ; 1 )

etc.

Thanks!!!!!!!