topic Re: Text string function in QlikView

Text string function

arsenal1983 — Tue, 09 Jun 2015 15:44:58 GMT

Hello,

I have column with partner ID and I would like to flag in my script partners with prefix ZD and the numer on the third place (ZD0, ZD3, ZD9 but without ZDQ).

any suggestions?

Luke

Re: Text string function

ramoncova06 — Tue, 09 Jun 2015 17:45:02 GMT

maybe something like

if(left(partner ID,3) <> 'ZDQ' and left(partner ID,2) = 'ZD', 'Yes','No') as ZDFlag

Re: Text string function

swuehl — Tue, 09 Jun 2015 17:50:05 GMT

If( Left( ID, 2) = 'ZD' and isnum(mid( ID, 3,1)), 'Yes','No') as Flag

Re: Text string function

maxgro — Tue, 09 Jun 2015 18:48:43 GMT

if(left([partner ID],2) = 'ZD' and match(right([partner ID],1),1,2,3,4,5,6,7,8,9,0), 'Yes','No') as flag

Re: Text string function

rwunderlich — Wed, 10 Jun 2015 00:21:03 GMT

Just because I've always wanted to find a use for the "precedes" operator:

=TextBetween([Partner ID],'ZD','') precedes 'A'

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Text string function

rbecher — Fri, 26 Jun 2015 19:13:35 GMT

..but watch out, help means precedes operator is using ASCII Comparison, but it's not:

= '9' precedes ':' => false

but

= ord('9') < ord(':') => true

So, my guessing is some other internal order is used.

Re: Text string function

MarcoWedel — Fri, 26 Jun 2015 21:44:39 GMT

another one:

IsNum(Num#(partnerID,'ZD0'))

hope this helps

regards

Marco

Re: Text string function

MarcoWedel — Fri, 26 Jun 2015 21:52:25 GMT

Re: Text string function

swuehl — Fri, 26 Jun 2015 21:59:18 GMT

Unfortunately, this also accepts codes with second char being any number like:

=isNum(Num#('Z17','ZD0'))

Probably because 'D' is a format code coincidentially.

Re: Text string function

MarcoWedel — Fri, 26 Jun 2015 22:13:39 GMT

'D1' also is flagged.

Maybe not the best solution after all

thanks

Marco