How do you count up the occurrences of <word> in a sentence? (or, in this case, find how many times "Nintendo" is in a 538?
sum(forEach(value.split(" "), temp, if(temp.contains("Nintendo"), 1, 0)))
Explanation:
A resource for librarians who have questions about Open Refine or want to share their recipes for manipulating data.