Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
text string 'SE38' is between strings 'SE16O*' and ' Z*'. Is there a script function to check for this?
Many thanks,
Leonardo
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
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.
I guess the space is a mistake. Otherwise we'll have to overload some operators. Does QlikView script language support that?
Got it. I would have never understood this by my own.