« Perspective | Main | APEX 4.0 is out!! »
Monday
Nov012010

Quick tip...

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

 

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>