We help IT Professionals succeed at work.

Want to include data that starts with a specific number

Becky Edwards
on
I have a field that I want crystal to evaluate, and if the field starts with the number 9, then I want to include that data.  I know where to put this code - in the section expert under suppression, I just don't know how to say it in crystal language.  Below is my attempt which did not work.  Please help.

and(totext({CLARITY_EAP.PROC_CODE}) like "9")
Comment
Watch Question

Top Expert 2011
Commented:
random guess... try using the wildcard indicator *

... like "9*"
Becky EdwardsEpic Clarity Developer

Author

Commented:
Wow - that worked!!! Thanks!
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
You could also use

and (totext({CLARITY_EAP.PROC_CODE}) StartsWith "9")

or

and (Left(totext({CLARITY_EAP.PROC_CODE}),1) = "9")

mlmcc

Explore More ContentExplore courses, solutions, and other research materials related to this topic.