Hello,

We have a custom text field where our users add information with hashtags. They can add as many hashtags as they want. However, we are having trouble accurately reporting on this data, as we cannot separate out the grouped hashtag data and report how many occurences by each hashtag. 

Is there a way to use a row level formula to accomplish this?

I tried using the following:

RIGHT( Case.Hashtags__c,(LEN( Case.Hashtags__c)-FIND("#", Case.Hashtags__c)))

However, all that is doing is taking text like this: 
#HHRGD1 #LUPA
And changing it to text like this: HHRGD1 #LUPA

Im wanting the formula to split HHRDG1 and LUPA so that i can see how many times each of those pop up. 

Hello,

We have a custom text field where our users add information with hashtags. They can add as many hashtags as they want. However, we are having trouble accurately reporting on this data, as we cannot separate out the grouped hashtag data and report how many occurences by each hashtag. 

Is there a way to use a row level formula to accomplish this?

I tried using the following:

RIGHT( Case.Hashtags__c,(LEN( Case.Hashtags__c)-FIND("#", Case.Hashtags__c)))

However, all that is doing is taking text like this: 
#HHRGD1 #LUPA
And changing it to text like this: HHRGD1 #LUPA

Im wanting the formula to split HHRDG1 and LUPA so that i can see how many times each of those pop up.