Oracle SQL - splitting Full Name separated by comma into First Name and Last Name

$0
=
$0
+
$0
No specific Bitcoin Bounty has been announced by author. Still, anyone could send Bitcoin Tips to those who provide a good answer.
0

How to parse Full Name separated by comma into First Name and Last Name in Oracle SQL? For example, the following string 'Smith, James' should be split into 2 strings 'Smith' and 'James'

Tags: ,

1 Answer - total earned - 0 BTC ($0 USD)

1
=
0
=
$0
Everyone, even non-registered users could send Bitcoin Tips to YOU if they are inspired by your answer!

Here you go, it works and does not throw exceptions even at the edge cases

select full_name,
       TRIM(SUBSTR(full_name, INSTR(full_name,',')+1, LENGTH(full_name))) first_name,
       TRIM(SUBSTR(full_name,1, INSTR(full_name,',')-1)) last_name
from 
(
select 'Smith, Michael' as full_name from dual union all
select 'Smith ,Michael' as full_name from dual union all
select 'Smith , Michael' as full_name from dual union all
select 'Lopes, Jennifer' as full_name from dual union all
select 'Lopes, Jennifer' as full_name from dual union all
select 'Lopes Jennifer' as full_name from dual union all
select 'Lopes' as full_name from dual union all
select 'Jlo,' as full_name from dual union all
select ',Jlo' as full_name from dual union all
select '' as full_name from dual 
)

Results:

enter image description here

SEND BITCOIN TIPS
0

Post Answer


Top 3 Tippers
Recent Tips

Will Bitcoin Tipping become a new Internet Culture?


Please share our story! THANK YOU!