Get text from a text field

[BertBoye]

Dear All

I am trying to extract text from a file containing a lot of text. I have a start value let

[Lee Smith]

Hi Bert

If your Key words "*start* and *End*" are going to remain the same, and you only want the one chunk of text in between, than this calculation will do what you want.

Trim(Middle(g_Text, Position(g_Text, "*start*", 0, 1) + Length("*start*"), (Position(g_Text, "*end*", 0, 1) - (Position(g_Text, "*start*", 0, 1) + Length("*start*")) - 1 )))

HTH

Lee