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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.