Count number of occurrences of specific words in a string
Hello I'm looking to create a new column in my dataset that counts the number of times a specfic word appears in a string. The words are separated by "*" in each row. Example table:Animal List1 dog*dog*cat*bird*dog2 dog*dog*cat*bird*dog*dog Output should beAnimal List Dog Count1 dog*dog*cat*bird*dog 32 dog*dog*cat*bird*dog*dog ...