Text Calculation

[stuj1026]

Hi .. Hopefully someone can help me.

I have 3 fields

(Textfield_one)

(Numberfield_One)

(Extractfield_one)

I have a text field (Textfield_one) with lines of text seperated by carrige returns.

Each line in (Textfield_one) has a sentence then a carrige return. The field can have up to 50 to 100 lines. and each line can have an odd number of words.

I now have a field which uses the patterncount function which will tell me how many lines I have by counting the carrige returns.

I need a calculation which will return any one of the lines based on a number in (Numberfield_One) If I put a 7 in a (Numberfield_One)it will return only line 7 from my (Textfield_one)into Extractfield_one)

Please help!!

Thanks Stu

[BobWeaver]

It' s simpler if you add a couple of intermediate calculated fields "Start" and "End" with the formulas:

Start= Position(Textfield_one & "

[stuj1026]

PERFECT!! It works Great Thank you very much.. you just saved me hours of work..

Now let spend the next 1/2 hour and figure out why this works!!

Thanks again

Stu