Extract first line of text

[innodat]

I feel really dim... but I can't figure out how to extract the first line of a text field. The lines are separated with proper line breaks.

I know I have to use the PatternCount and Let function, and somehow define a start and end point with the ¶.

Anyone?

[comment]

Try:

GetValue ( Textfield ; 1 )

[innodat]

That totally worked!

The simplicity amazes me... thank you.

[innodat]

Actually, there seems to be a problem with this approach.

With GetValue (field; 1), the resulting variable contains the entire first row of the text (visible in data viewer), but when I use the variable to set a field in another table... only the first word of the first line appears.

??

What could that be?

[comment]

Unfortunately, forum's attachments are not working at the moment, so I cannot see what you tried to show us.

[innodat]

Never mind... it's my own stupidity.

The field I was inserting the text was a date field. The first value of the line of text was a date - so that's all it inserted.

Duh!

Thank you for your help, comment!

Edited September 24, 2008 by Guest