Parsing Text

[#1]

Hello Everybody,

I want to pull out a string of text from a  field(Text) within my Qlikview. The text has defined strings that open the string that I want to capture and close the string that I want to capture. The number of characters that I want to capture is not definite. There are multiple fields that I want to pull out of this field. Please help me write this script.

So far I got:

LOAD Text,

          IF(index(Text, 'openstring'), mid(Text,11, ....and then this is where I get lost.

I'm assuming there needs to be a len(), but I am unsure of how to define the string with the 'openstring' and 'closestring'

Thanks in advance!

[CELAMBARASAN]

Hi,

     May be Something like this

     SubField(SubField(FieldName,'ClosedString',1),'OpenString',1)

Celambarasan

[#3 · Accepted solution]

I figured it out. TextBetween(Text, 'openstring','closestring') worked perfect.