How to extract numbers after string using regexp?

Question

I need to extract the number/numbers that come after the last letter in a given string, using regexp or any other possible function.

For example, if the string is 'a23kfj879lp999', I need only 999 since the last letter in the string is p.

Razvan · Accepted Answer · 2017-10-20 08:41:41Z

1

Use the REGEX_SUBSTR function:

SELECT REGEXP_SUBSTR('a23kfj879lp999', '([0-9]+)$') FROM dual

Explanation:

REGEX_SUBSTR simply extracts the first substring from the source string that matches the respective pattern.

Syntax:

REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] )

edited Oct 20, 2017 at 8:41

answered Oct 20, 2017 at 8:15

Razvan

2,60621 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Frank Over a year ago

An explanation would be appreciate

Mano Over a year ago

@Frank [0-9] at first means the output should start with a numerical and + says numerical can occur 1 or more times. $ at the end indicates the string ends there ie. no more characters are present after the occurence of numericals.

Collectives™ on Stack Overflow

How to extract numbers after string using regexp?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related