Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help locating a string within a field

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

1 Reply
Not applicable
Author

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.