I have a column with of strings joined with “,” with an example being “john,dora,sally” and in two other columns I have individual names and salary with examples being “john” and 25 respectively.

How do I split the first string to find the matches in the name column and get the output as the sum of all the matches’ salaries?