How to check column that contain letter and number

[DY94]

Hello,

My columns must contains 2 letter and 4 number like this (AV1234)

How can i check this ?

Please anyone it's Urgent !

Thank you.

[Anonymous]

Hi

Create a user routine and write a function to check it using regex, call the routine in the job.

Regards

Shong

[manodwhb]

@DY _BI​ , you can try to use the below one

StringHandling.LEN((row1.col).replaceAll( "[^\\d]", "" ))

[DY94 · Accepted solution]

Hello @Shicong Hong​ ,

Thank you for your answer !

This is my first time with routine ! and it works !

My code:

public static Boolean MyPattern(String str) {

String stringPattern = "[A-Z]{2}[0-9]{4}"; 

boolean match = Pattern.matches(stringPattern, str);

return match ;

  }

[DY94]

Thank you @Manohar B​