Extract Last Name only from Lastname,Firstname

Question

I just started working with Oracle recently so please bear with me.

I have a column of names as LASTNAME,FIRSTNAME and I need to extract JUST the last name. I know how to do this in excel, where I want to so search for the "," find the length of characters before the comma and return those characters.

I know to use SUBSTR as my LEFT() function, but I'm stuck from there.

INSTR is the function you can use to find the first comma – Caius Jard Jul 10 '17 at 15:32 — Caius Jard, Jul 10 '17 at 15:32

score 1 · Answer 1 · answered Jul 10 '17 at 15:30

1

One method in Oracle is regexp_substr():

select regexp_substr(name, '[^,]*')

answered Jul 10 '17 at 15:30

Gordon Linoff

1,242,037
58
646
786

Extract Last Name only from Lastname,Firstname

1 Answers1