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

[Dave Funk]

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?

[Nic Brough -Adaptavist-]

I'd use a scripted field to count up the commas.  You will need some code to do this no matter what, there's nothing built-in that can do it.

[Dave Funk]

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.

[John Funk]

@Dave Funk  - did you get this sorted?

[Dave Funk]

Not really - just exported to Excel.