Count on specific Field Content

[#1]

Is there a way to extract a specific text portion of a field and conduct a count on that specific item? What would the syntax be and where would it appear (load script or sheet object)?

Also when extracting that specific text can I import it into a separate field?

Field Content Example: Apple Tree , Orange Tree, Lilac Tree

I would want to extract the word 'Tree' into a separate field and also count the different varieties of apple, orange, and lilac

[Gysbert_Wassenaar]

LOAD

     MyField,

     if(substringcount(MyField, 'Tree'),'Tree') as FieldThatContainsTheValueTree,

     if(substringcount(MyField, 'Tree'), trim(replace(MyField, 'Tree','')))  As TreeVariety

FROM ...

In the front end you can create a chart object with TreeVariety as dimension and count(TreeVariety) as expression.