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

[#1]

Good afternoon,

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

Many thanks,

Leonardo

[swuehl]

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

[Peter_Cammaert]

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.

[Peter_Cammaert]

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

[sunny_talwar]

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