Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

question about regular expression

ben512Nov 12 2007 — edited Nov 14 2007
Hi,

I have a column SAMPLE_ID in table TEST1.

The values in this column for example are

SAMPLE_ID
test_100_1_1
test_12_2_3
test_1_10_1
test_1_10_15

I would like to cut all characters beginning with the third underscore ('_') from the rest of the strings.
It should looks like this one:

SMAPLE_ID
test_100_1
test_12_2
test_1_10
test_1_10

I think I have to work with regular expressions and tried something but I can not find a solution.
Can anybody help me, please?


Thanks,
ben

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 12 2007
Added on Nov 12 2007
8 comments
2,478 views