@rnm1978 asked an interesting question over Twitter, along the lines of:
“My column has “YYYY / MM” in it – how can I amend the column so that the date is in “PMM-YY” format? eg. ‘Here is some text 2010 / 04 and more text’ becomes ‘Here is some text P04-10 and more text’.”
REGEXP_REPLACE to the rescue!
SQL> with mt as (select 'Thisismy string 2010 / 04 and there''s more over here' col1 from dual union all
2 select 'Just plain vanilla string' col1 from dual union all
3 select 'Have some 2009 / 02 more text here' col1 from dual)
4 select col1, regexp_replace(col1, '([[:digit:]]{2})([[:digit:]]{2}) / ([[:digit:]]{2})',
5 'P\3-\2') col1a
6 from mt;
COL1 COL1A
------------------------------------------------------- --------------------------------------------------
Thisismy string 2010 / 04 and there's more over here Thisismy string P04-10 and there's more over here
Just plain vanilla string Just plain vanilla string
Have some 2009 / 02 more text here Have some P02-09 more text here
Recent Comments