topic Re: Script: checking whether a text string is between other text strings in QlikView

Script: checking whether a text string is between other text strings

Wed, 27 Jan 2016 16:50:42 GMT

Good afternoon,

text string 'SE38' is between strings 'SE16O*' and ' Z*'. Is there a script function to check for this?

Many thanks,

Leonardo

Re: Script: checking whether a text string is between other text strings

sunny_talwar — Wed, 27 Jan 2016 17:10:04 GMT

Not sure I understand your requirement? Can you elaborate?

Re: Script: checking whether a text string is between other text strings

Wed, 27 Jan 2016 17:45:11 GMT

Hi Sunny,

I would need a function that can check if 'SE38' is between 'SE16O*' and ' Z*', which the case. A similar check would be if 'SE38' is between 'SEF*' and ' Z*', which is not the case.

Thanks

Re: Script: checking whether a text string is between other text strings

sunny_talwar — Wed, 27 Jan 2016 18:33:15 GMT

I am still not sure what exactly you are trying to do. Can you share few lines of data with expected output?

Re: Script: checking whether a text string is between other text strings

maxgro — Wed, 27 Jan 2016 18:41:11 GMT

did you mean?

load

'SE38' > 'SE16O' and 'SE38' < 'Z',

'SE38' > 'SEF' and 'SE38' < 'Z'

AutoGenerate 1;

Re: Script: checking whether a text string is between other text strings

swuehl — Wed, 27 Jan 2016 19:15:36 GMT

Maybe something like

=Wildmatch( Textbetween(TEXTFIELD,'SE160',' Z'),'*SE38*')

Re: Script: checking whether a text string is between other text strings

MarcoWedel — Wed, 27 Jan 2016 20:37:31 GMT

maybe using the relational operators precedes/follows.

regards

Marco

Re: Script: checking whether a text string is between other text strings

MarcoWedel — Wed, 27 Jan 2016 20:49:31 GMT

like this:

table1:

LOAD *,

string follows 'SE16O' and string precedes 'Z' as Flag

Inline [

string

SE38

68HC11

TI35

SN7400

QV12

_SE38

\SE38

+SE38

SE5

SE05

];

hope this helps

regards

Marco

Re: Script: checking whether a text string is between other text strings

Peter_Cammaert — Wed, 27 Jan 2016 23:39:21 GMT

Wow, learned something new. And you beat a few high-profiles along the way Maybe there is an advantage to being a foreign language-speaker after all.

Re: Script: checking whether a text string is between other text strings

sunny_talwar — Wed, 27 Jan 2016 23:41:45 GMT

I still don't understand the requirement

Re: Script: checking whether a text string is between other text strings

swuehl — Wed, 27 Jan 2016 23:52:50 GMT

I must admit I haven't understood the requirement neither, but isn't there a space before Z in the OP's post?

string follows 'SE16O' and string precedes ' Z' as Flag

Does this fulfill the requirement then

Re: Script: checking whether a text string is between other text strings

Peter_Cammaert — Wed, 27 Jan 2016 23:53:24 GMT

I guess (and Marco did too) that in his second post, Leonardo explained that he was looking for a test that decides whether the ASCII value of a particular field falls between two text strings.

SE160 < SE38 < Z* = true

SEF < SE38 < Z* = false

You can't do that with normal relational operators because they work on numbers. Precedes & Follows work on strings.

Re: Script: checking whether a text string is between other text strings

Peter_Cammaert — Wed, 27 Jan 2016 23:56:22 GMT

I guess the space is a mistake. Otherwise we'll have to overload some operators. Does QlikView script language support that?

Re: Script: checking whether a text string is between other text strings

sunny_talwar — Thu, 28 Jan 2016 00:19:16 GMT

Got it. I would have never understood this by my own.