| gameid | year | credits1 | credits2 |
| 1 | 1996 | Aleksandr Kravchuk,Alexey Menshikov,Alexey Menshikov,Rostislav Garbar | George Bain,Ted Regulski |
| 2 | 1995 | David H. Tolley,David H. Tolley,Steven Metcalf,Steven Metcalf | James Tripp,Paul Margrave,Steven Metcalf |
I have a dataset of people's credit for a video game portrayed in the table above. Each name is separated by a comma, and it varies from 5 people to 1500people.
Is there a way to see how many names are in common between two variables of credits1 and credits 1?
I was searching through the forum but could not find any topic about finding a number of matching multiple words separated by a comma.
Thank you!
0 Response to Calculate how many words separated by a comma match between two string variables
Post a Comment