I'm trying to count the number of times the word "Title" occurs within a memo field (500-2000 chars).

Is this possible to do within Crystal??

Thanks

Edited by saoco77 - 02 Sep 2009 at 6:29am

I'm receiving the error message

A loop was evaluated more than the maximum number of times allowed.

If the word Title is not contained within the field the formula works fine.

I still couldn't get your formula to work. I think there may be an issue with the stop mechanism on the loop.

Listed below is the solution I finally came up with which breaks the process into two formulas.

@formula1

stringvar array SplitText := split({table.field}, " ");
stringvar array FilterText := filter(SplitText, "Letter");
stringvar iJoin;

iJoin := Join(FilterText,"");
iJoin


@formula2

evaluateafter({@formula1});

if isnull({@formula1}) then 0 else
(length({@formula1})/6)

Thank you again for your assistance, it is appreciated.

Edited by saoco77 - 03 Sep 2009 at 7:57am

I know this is an older post but I thought this might help for other people looking for this. The code above helped me come up with this solution.

stringvar array textcheck := split({table.field}, "TEXT");
count(textcheck)-1;

Change the TEXT to what your looking for and the table will be split by that text. Each item in the array will then have the text your looking for. Subtract by one because the first split will be the first section without the word.
I ended up coming to this because there were some fields that the users were using commas instead of spaces to sperate the items

Edited by Aliqux - 26 May 2016 at 5:14am