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
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
SELECT LOWER(regexp_replace('Smith, John R', '(.+)(, )([A-Z])(.+)', '\3\1', 1, 1)) FROM DUAL; -- returns "jsmith"