on 05-19-2014 1:37 PM
Hi
I am using BODS 14.1.1.210 .
I would like to filter one column which has the pattern AXXXXX (where X can be number or alphabet or combination of both)
I treid to use match pattern but I X means alphabet and 9 means number but how can I filter all the combinations of numbers or alphabets.
for example;
Input
A12345
A1234567
AabcdE
Aabcde
A12asd
Aas12d
Askljfdadf
Output
A12345
AabcdE
Aabcde
A12asd
Aas12d
Cheers!
Hi Josh,
Instead of match patten use match_regex for your requirement . You can use like this .
OUTPUT = decode(match_regex(INPUT,'[A-Z][A-Za-z0-9]{5}',null)<>0,$INPUT,null );
You can filter on this column like OUTPUT is not null means you can get matched values. You need one additional query transform for filter .
Thanks & Regards,
Ramana.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.