September 1, 200322 yr Dear All I am trying to extract text from a file containing a lot of text. I have a start value let
September 1, 200322 yr 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
Create an account or sign in to comment