How do I count the number of commas in a multi-line custom field?

Question

I am running version 6.4.3.

I have a multi-line custom text field that contains entries separated by commas.   I want to be able to run a query that returns Issues sorted by the number of entries in that custom field.  Counting the number of commas in the field would do the trick, I think.

Any ideas?

Dave Funk · Answer

Not really - just exported to Excel.

John Funk · Answer

@Dave Funk  - did you get this sorted?

Dave Funk · Answer

Thanks.

Another solution is to export to Excel, and use an Excel formula to count the commas.  The drawback here is that I can only export 1000 rows at a time.  I have a little more than 2800 Issues that I need to look, so this isn't *too* painful.