Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Find string function help

Posted on 2012-03-14
4
Medium Priority
?
463 Views
Last Modified: 2012-03-15
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?
0
Comment
Question by:j2911
  • 2
  • 2
4 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 37720125
Try using

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

mlmcc
0
 

Author Comment

by:j2911
ID: 37720271
Thanks.

Can you explain what does the >0 do in this statement?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 37722571
InStr returns the location of the search text.  If it is 0 then the text was not found

mlmcc
0
 

Author Comment

by:j2911
ID: 37724875
Thank you.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses
Course of the Month10 days, 16 hours left to enroll

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question