Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

To filter alphanumeric combination, is it match pattern?

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!

Tags:
Former Member
replied

Hi Josh ,

Yes you can use in the where clause like

decode(match_regex(INPUT,'S[a-zA-Z0-9]{2}-A[a-zA-Z0-9]{6}',null)<>0,INPUT,null ) is not null Instead of adding one more query transform and field.

Thanks & Regards,

Ramana.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question