Parsing Text

Thu, 26 Apr 2012 18:05:54 GMT

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!

Parsing Text

CELAMBARASAN — Thu, 26 Apr 2012 18:11:06 GMT

Hi,

May be Something like this

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

Celambarasan

Parsing Text

Thu, 26 Apr 2012 18:16:26 GMT

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

topic Parsing Text in QlikView

Parsing Text

Parsing Text

Parsing Text