I have a field which contains a series of words separated by commas.
I am wondering if it is possible to count the number of times the letter 'G' occurs. Alternatively it might be possible to split the field by commas and go down another avenue...
Here's a few example fields:
Essentially I would like to produce a new column which tells me how many times 'Green' appears in each field.