Splitting a field into one field per line

[OffTheDeepEnd.com]

I am not sure if there is a function that would be able to do this but I figured I might have just missed it. I want to do the following:

Adress Field:

Company Name

Address

City, State, Zip

Change it to individual fields per line:

AddrLine1: CompanyName

AddrLine2: Address

AddrLine3: City, State, Zip

Thanks for any help!

[John Mark Osborne]

Too bad you don't have FileMaker 7 or later. FileMaker 7 introduced LeftValues, RightValues and MiddleValues which would make this a lot easier. In FileMaker 6 you can use the following formulas.

Company:

Left(Name; Position(Name; "¶"; 1; 1) - 1)

Address:

Middle(address, Position(address, "¶", 1, 1) + 1, Position(address, "¶", 1, 2) - Position(address, "¶", 1, 1) - 1)

City:

Left(Right(address, Length(address) - Position(address, "¶", 1, 2)), Position(Right(address, Length(address) - Position(address, "¶", 1, 2)), ",", 1, 1) - 1)

State:

Middle(Right(address, Length(address) - Position(address, "¶", 1, 2)), Position(Right(address, Length(address) - Position(address, "¶", 1, 2)), ",", 1, 1) + 2, 2)

Zip:

RightWords(address, 1)

And, yes! You should separate the city, state and zip into separate fields. This will make it possible for you to sort on the city or state.