Parse out word between two characters SQL Netezza

Question

I am having trouble finding the correct syntax to parse out a word between two characters in Netezza.

PATIENT_NAME
SMITH,JOHN L
BROWN,JANE R
JONES,MARY LYNN

question from:https://stackoverflow.com/questions/65833277/parse-out-word-between-two-characters-sql-netezza

Answer 1

I think Netezza supports regexp_extract(). That would be:

select replace(regexp_extract(name, ',[^ ]+'), ',', '')

Or regexp_replace():

select regexp_replace(name, '^[^,]+,([^ ]+)( |$).*$', '1')