<div>
Are you sure you want to do this in Crystal Reports? Which db are you using? Will it be acceptable to have solution there instead?
</div>


Are you sure you want to do this in Crystal Reports? Which db are you using? Will it be acceptable to have solution there instead?

<div>
Thank you for your response Nitin, I run Crystal reports against a SQL database. Crystal also has some limited ability to do SQL queries. Crystal reports is what I typically use so it seems like the way to go.
</div>


Thank you for your response Nitin, I run Crystal reports against a SQL database. Crystal also has some limited ability to do SQL queries. Crystal reports is what I typically use so it seems like the way to go.

<div>
In playing with some available commands I found the below statement that seems to be working in Crystal Reports :-<br />
Ubound(Split({ZapData.Char<wbr />Confidence<wbr />},&quot;,&quot;))
</div>


In playing with some available commands I found the below statement that seems to be working in Crystal Reports :-
Ubound(Split({ZapData.CharConfidence},","))

<div>
To add some additional findings, it seems I'm closer but still have some challenges. Should my value have for example 7 commas as expected but the last value is 'null' (71,100,63,100,100, ) the results is also 7. The result for the example mentioned in brackets should = 6
</div>


To add some additional findings, it seems I'm closer but still have some challenges. Should my value have for example 7 commas as expected but the last value is 'null' (71,100,63,100,100, ) the results is also 7. The result for the example mentioned in brackets should = 6

<div>
Thank you and as always great solution.
</div>


<div>
<div class="content wysiwyg-content">
I have a string value {dbo.CharConfidence} field that typically has 7 values separated by a comma <b>(82,81,81,85,93,67,8)</b> I am looking for a formula that will count the individual 'instances' separated by a comma. the example mentioned in bold &nbsp;= 7
</div>
</div>


I have a string value {dbo.CharConfidence} field that typically has 7 values separated by a comma (82,81,81,85,93,67,8) I am looking for a formula that will count the individual 'instances' separated by a comma. the example mentioned in bold  = 7

Count string value instances seperated by a comma in field

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.