Solved

Find string function help

Posted on 2012-03-14
4
457 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 100

Accepted Solution

by:
mlmcc earned 500 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 100

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Formula to get month and year from date 5 61
Pictures In Crystal 10 49
Crystal Reports 2008 6 34
Crystal reports Cross Tab - Display dates even if no data returned. 20 108
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 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