Splitting the value of a field using Table Filter and Charts

[Craig.Harley]

2nd basic question of the day

I am returning a list of values in a table that are split into 4 categories looking at the raw data. the format is as follows

create-aaa

read-bbb

update-ccc

delete-ddd

create-eee

read-fff

I want to be able to show the info as a simple chart for the totals of the 4 categories create, read, update and delete, so in the example above i would see 

create = 2, read=2, update=1 and delete=1

is there a simple way of doing this without going into complex CQL in the table transformer macro?

[Tim Kopperud · Accepted solution]

@Hi @Craig.Harley,  will this code example help solving the problem? 

SELECT ColA::string->split("-")->0 as res 
FROM T*

Source looks like this

Result looks like this:

TimK

[Craig.Harley]

Thats perfect, thank you ever so much Tim

[Stiltsoft support]

Thank you @Tim Kopperud for your help, couldn't have given a better example ourselves!