CODE EXAMPLE FOR SQL

sql redshift split into first and last name

SELECT
    user_id,
    SPLIT_PART(employee_name,',',1) as employee_last_name,    
    SPLIT_PART(employee_name,',',2) as employee_first_name,
    employee_name,
FROM table

Syntax: SPLIT_PART(string, delimiter, part)