Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
match(left(Article Number,2),'CO') and isnum(mid(Article Number,2,1))
you can also use your wildmatch to replace the match.