Regex in oracle SQL - return all numbers in a string, comma-delimited

Question

My input value is something like:

Value:123 with subvalues:[134,135,136]

I just want to pull all of the numbers from this and keep them comma-delimited if they are seperated by at least one non-digit character. I'm using this right now:

regexp_replace(message,  '[^[:digit:]]')

This pulls the numbers, but obviously replacing even the spaces between those numbers with nothing. How can I get the result of:

123,134,135,136

Honestly, it sounds like what you are doing should be addressed in the application logic, not in the database. — Mike Brant
– Mike Brant, Commented Jun 25, 2013 at 20:07

Markus Jarderot · Accepted Answer · 2013-06-25 21:32:12Z

2

select
    regexp_replace(
        regexp_replace(
            'Value:123 with subvalues:[134,135,136]',
            '[^[:digit:]]+', ','),
        '^,+|,+$'
    ) as s
from dual;

Result:

s
---------------
123,134,135,136

answered Jun 25, 2013 at 21:32

Markus Jarderot

89.7k23 gold badges141 silver badges142 bronze badges

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

Collectives™ on Stack Overflow

Regex in oracle SQL - return all numbers in a string, comma-delimited

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related