Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tbl(id int PRIMARY KEY, name_loc text);
INSERT INTO tbl VALUES
  (1, '{"Charlie – White Plains, NY","Wrigley – Minneapolis, MN","Ana – Decatur, GA"}')
, (2, '{"Marry Lou – White Plains - Whatever","J. R. R. – Minneapolis, MN","John-Paul – Decatur, GA"}')
;
2 rows affected

SELECT t.id, x.names
FROM   tbl t
CROSS  JOIN LATERAL (
   SELECT string_agg(split_part(elem, ' – ', 1), ', ') AS names
   FROM   unnest(t.name_loc::text[]) elem
   ) x
ORDER  BY id;


id
names


1
Charlie, Wrigley, Ana

2
Marry Lou, J. R. R., John-Paul


SELECT id, string_agg(split_part(elem, ' – ', 1), ', ') AS names
FROM   (SELECT id, unnest(name_loc::text[]) AS elem FROM tbl) t 
GROUP  BY id
ORDER  BY id;


id
names


1
Charlie, Wrigley, Ana

2
Marry Lou, J. R. R., John-Paul