question about regular expression
ben512Nov 12 2007 — edited Nov 14 2007
I have a column SAMPLE_ID in table TEST1.
The values in this column for example are
I would like to cut all characters beginning with the third underscore ('_') from the rest of the strings.
It should looks like this one:
I think I have to work with regular expressions and tried something but I can not find a solution.
Can anybody help me, please?