Help needed ! on Backend Script

kiranpatil123 — Mon, 27 May 2019 09:49:01 GMT

Hi All ,

I have column with following fields ,

CO1234

CO4567

COTERS

CO7654

COXYZ

CONTRACT 12345

CO456

i need to mark all the fields with starting CO and then numerical numbers ( from starting with 3rd position ) . Please help

i gave WildMatch([Article Number],'CO*') and keepchar([Article Number],'123456789') I'm getting the values but iam getting with CONTRACT 12345 value ( in which i dont need this )

Advance thanks

Re: Help needed ! on Backend Script

bramkn — Mon, 27 May 2019 09:56:11 GMT

match(left(Article Number,2),'CO') and isnum(mid(Article Number,2,1))

you can also use your wildmatch to replace the match.

topic Re: Help needed ! on Backend Script in QlikView

Help needed ! on Backend Script

Re: Help needed ! on Backend Script