Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Help needed ! on Backend Script

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

1 Reply
bramkn
Partner - Specialist
Partner - Specialist

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

you can also use your wildmatch to replace the match.