Deleting text

[gareece]

I have an FM7 file that includes a field called 'Settlement Letter Content". In this field users freely type a letter which starts with a salutation and then the main content:

For example:

"Dear John,

Your account is now settled........"

I want to be able to extract the "Dear John," part and add it to another field via a calculation.

I am unsure how to extract/trim the content of the "Settlement Letter Content" field so it only takes the saluation.

I appreciate any help.

[Raybaudi]

Assuming that the salutation is always the first row:

Substitute ( LeftValues ( Settlement Letter Content ; 1 ) ; ¶ ; "" )

[gareece]

Works perfectly! Thanks very much.