Oracle PL/SQL: RegExp: Append first name first letter to last name - Example of using a regular expression to get the first letter of the <br /> first name and concaten

Quick Search:

Oracle PL/SQL: RegExp: Append first name first letter to last name

Jump to:

Snippet Name: RegExp: Append first name first letter to last name

Description: Example of using a regular expression to get the first letter of the
first name and concatenating it to the last name.

Also see:
» Regular Expressions: REGEXP_SUBSTR
» Regular Expressions: REGEXP_LIKE
» Regular Expressions: REGEXP_REPLACE
» Regular Expressions: RegExp examples t...
» Regular Expressions: RegExp examples t...
» Regular Expressions: RegExp examples o...
» Regular Expressions: Regexp Cheat Sheet

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 12th, 2009

SELECT LOWER(regexp_replace('Smith, John R', 
             '(.+)(, )([A-Z])(.+)', 
             '\3\1', 1, 1)) 
  FROM DUAL;
 
-- returns "jsmith"