Replace parts in a string using REGEXP_REPLACE

Question

Hi I have a string in oracle like this:

 temp_a, temp_b, temp_c

What I want to get is :

 e.temp_a, e.temp_b, e.temp_c

So I want to put an "e." before every part in this string
I searched in internet and I found examples to split the string or to replace simpler strings but nothing to guide me through my problem

Maheswaran Ravisankar · Accepted Answer · 2014-09-23 15:08:19Z

1

select regexp_replace('temp_a, temp_b, temp_c',
              '([a-zA-Z0-9_]+)(,?)', 
               'e.\1\2') from dual;

This should work.

edited Sep 23, 2014 at 15:08

answered Sep 23, 2014 at 15:00

Maheswaran Ravisankar

17.9k6 gold badges50 silver badges69 bronze badges

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

1 Comment

Bacs Over a year ago

Upvoted because it works and it's what was asked for. I agree with Patrick that there's no need for regex here, and I would tend to avoid them (in Oracle) whenever there's a reasonably readable alternative.

Bacs · Accepted Answer · 2014-09-23 14:32:01Z

1

I just noticed you're specifically asking for regex, but for what it's worth I would probably do it like this:

rtrim( replace( 'e.'||your_string, ', ', ', e.'), 'e.')

edited Sep 23, 2014 at 14:32

answered Sep 23, 2014 at 14:02

Bacs

9191 gold badge10 silver badges16 bronze badges

4 Comments

Nianios Over a year ago

No I want it generic. This is just an example

Bacs Over a year ago

Thought it was too easy. :) Generic in what ways though? What would be constant and what not? Always comma separated values, always the "e." prefix?

Nianios Over a year ago

always comma separated and always the e. prefix. The words will be changing

Patrick Bacon Over a year ago

While regular expressions are fun and enjoyable, I think there is no need for them here. It is all about the right tool/function for the right circumstance. Maheswaran does provide a good regular expression alternative.

Collectives™ on Stack Overflow

Replace parts in a string using REGEXP_REPLACE

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related