extract string using regex [message #644858] |
Thu, 19 November 2015 02:06 |
|
m.abdulhaq
Messages: 254 Registered: April 2013 Location: Ajman
|
Senior Member |
|
|
i want to extract the numbers before mm and after last 'x' from the following string using regex.
'BUS1078x622x25x50x5213mm, Gr. 50'
'BUS2000x400x30x30x9020mm ,astm'
'BUS2000x400x30x30x90200mm',a36
--required output is
5213
9020
90200
|
|
|
|
|
|
Re: extract string using regex [message #644887 is a reply to message #644864] |
Thu, 19 November 2015 06:09 |
Solomon Yakobson
Messages: 3267 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Or simpler (assuming 11G or higher):
WITH qry AS
(SELECT 'BUS1078x622x25x50x5213mm, Gr. 50' as text FROM dual UNION ALL
SELECT 'BUS2000x400x30x30x9020mm ,astm' FROM dual UNION ALL
SELECT 'BUS2000x400x30x30x90200mm' FROM dual )
select regexp_substr(text,'x(\d+)mm',1,1,null,1)
from qry
/
SY.
|
|
|