how to delete a second line in a paragraph?

[hartmut77]

Hi I have a text field called "temp"

it has 2 lines or pne paragraph return

How can I remove the second line only in the field "temp"

Thanks

FileMaker Version: 7

Platform: Mac OS X Panther

[The Shadow]

FM7 has new "value" methods that operate on full lines of data, just like LeftWords() etc. methods operate on full words. So:

LeftValues( temp, 1 ) & RightValues( temp, ValueCount(temp) - 2 )

will return all but the second line. BUT, the RightValues() call will add a newline at the end of your text even if there wasn't already one there.

Similarly:

LeftValues( temp, 1 )

will return only the first line (with a newline)

and:

MiddleValues( temp, 2, 1 )

is just the second line (always with a newline).