Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.