Reg Ex

[janejeba]

How to extract the following sub string from input string using regex ?

Extract String : SP123456789.xls

Input String : I'm Indian - I like India - SP123456789.xls

[ The count of extract String always remain fixed but the number pattern will vary ]

 

[Jan Čech]

Hi,

Try this link https://regex101.com/

JC

 

[JackT]

I'd say if the format is stable enough like XXXX - XXXXX - SP123456789.xls.

Then you'd be able to get by string manipulation.

However, to answer the question, regex will be like below if its always two bit of char and nine bit of digs.

\w{2}\d{9}

It also can be like below if you wanna enforce upper case.

[A-Z]{2}\d{9}

Cheers,
Jack

 

[Christer]

Regex: \w{2}\d{4,}.xls

https://regexr.com/ to test more

 

[janejeba]

Jack,

It's working fine, Thanks.

 

[janejeba]

@Christer
What is the use of \d{4, } here

 

[JackT]

@Christer
What is the use of \d{4, } here

That means 4 or more digits.

Cheers,
Jack