Hi

I have a text field 'Par" with 5 carriage returns in each record.

Sometimes there are only 4 lines. So I would like to have a calculation that

would send the last line to a field called "five" when it occurs.

So it would normally have 4 lines in the field "par" and when there is a five line exception I would a calc to send the 5th line to field "five"

I would like your help please

Thanks

Dave

FileMaker Version: 7

Platform: Mac OS X Panther

define par1_4 as a calculation:

Left(par, Position(par, "

Yes it does - and thanks very much

with FM7 it's even easier.. you can use the LeftValues() function to grab any line of a return delimited list.

Reed is correct, I didn't notice that you're using FM7 (my bad...)

Here are the functions in FM7:

par1_4: LeftValues (par; 4)

par5:

If( Length (RightValues (par; 1)) > 1;

RightValues (par; 1);

"No fifth line"

)

or

If( Position(par; "