It Worked Yesterday! An Application Express/Life Blog from Brian T Spendolini

I'll get on posting more often now but here is a quick tip/code sample...

Sometimes you get customer/person info in the last, first format and you need first last...here is a quick reg expression to take care of that...

select REGEXP_REPLACE(
'last, first',
'(.*), (.*)', '\2 \1') name
from dual;

NAME
----------
first last

Article originally appeared on It Worked Yesterday! An Application Express/Life Blog from Brian T Spendolini (http://www.itworkedyesterday.com/).

See website for complete article licensing information.