Help locating a string within a field

Tue, 03 Nov 2009 21:13:15 GMT

Hi all,

I need to be able to locate instances where a field contains a certain string in a certain position, or to take part of a string based on its position.

How, within QV script can I take a string, for example, that starts with "&searchstring="

I need to use whatever comes AFTER that string and before the NEXT "&"

for example:

&searchstring=AWD&

I need to be able to extract the "AWD" from that string.

any help is appreciated,

Regards,

Matt

Help locating a string within a field

Tue, 03 Nov 2009 22:09:24 GMT

You could probably use TextBetween().

Try this (where SEARCHER is the whole string):

TextBetween(SEARCHER, '&searchstring=', '&')

That looks like it will work whether or not there is another query string after that one.

topic Help locating a string within a field in QlikView

Help locating a string within a field

Help locating a string within a field