We help IT Professionals succeed at work.

Find string function help

j2911
j2911 asked
on
This is the function I am using in excel.

=ISERR(FIND("NOT FOUND",[@address_check]))

What this does is if it finds "NOT FOUND" in my field called address_check then it returns a "TRUE" else it returns "FALSE".

I am trying to figure how to code this for Crystal Reports?  
What function checks for the string "NOT FOUND" in a field?
What if the field contains more than "NOT FOUND" in the string and all I want it to find is the "NOT FOUND" part of the string?
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Try using

    InStr({@address_check},"Not Found") > 0

mlmcc

Author

Commented:
Thanks.

Can you explain what does the >0 do in this statement?
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
InStr returns the location of the search text.  If it is 0 then the text was not found

mlmcc

Author

Commented:
Thank you.

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