Split address into 3 fields? How Please

[Kathy Relyea]

Hello all

I am new and I need help.

I have a field with 3 lines in it that is an address.

Joe Smith

123 Main Street

New York, New York 10019

Is there a way for me to extract the first line and send it to a field called "name"

the second line to a field called "address"

and the third line to a field called "City"

I think this can be done but not sure how.

Thank you

K

[ESpringer]

Welcome to FM Forums! (Can a relative newbie say that?)

You want three calculation fields to look out for the "

[ESpringer]

By the way, on a Mac I get the "

[Kathy Relyea]

Thanks so much for such a great explanation.

But what do you mean by "tight text" ?

I am sorry but I dont' know what you are referring to or if it is a field I should have.

But I thank you for such a detailed explanation.

All the rest makes good sense to me.

Thanks

K

[Kathy Relyea]

Also

I get an error on the third calculation it says there are too many separators in this function.

It seems to be just like the second one.

I don't get it.

K

[ESpringer]

Kathy,

Oops -- I was pulling the calc in from another database where I had a "tight text" field, and I thought I had made all the replacements. I wanted to refer only to whatever field you have, FullAddress, or whatever you call it.

So, the third calc should be:

[color:"blue"]Right(FullAddress,Length(FullAddress)-Position(FullAddress, "

[Kathy Relyea]

That was it

THANKS!

K