Extract substring with regex

[andrea93]

Hi,
i have a variable string,
but there is alway a sub string: AB123456789.
The lenght is static, mat the number can be variable (es. AB987654321)

Is there a regex to extract this substring?

Tnks

 

[Chakravarthy GRK]

[A-Ba-b]{2}[0-9]{9} chk if this works.

 

[andrea93]

[A-Ba-b]{2}[0-9]{9} chk if this works.

I Will try
Can you explain the first part? [A-Ba-B]

 

[Chakravarthy GRK]

[A-B] : Upper case alphabets between A-B
[a-b] : lower case alphabets between a-b

if the alphabets are from A-Z use [A-Z]
{2} Implies the first two letters in your string
[0-9] implies any numbers between 0-9
{9} the next 9numbers in your string

considering your string as alpha number aplha{2}Numeric{9}

 

[andrea93]

[A-Ba-b]{2}[0-9]{9} chk if this works.

Don't works

 

[Chakravarthy GRK]

Can u attach a screenshot of your data item which has that string & sub string

 

[robinjens1]

I Will try
Can you explain the first part? [A-Ba-B]

As I can see, you're not 100% secure about how regular expressions work. Here is a video explaining it in detail. After watching you will be able to write your own regex with ease.

Enjoy;