Solved

Find string function help

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
IF THEN Statement not working 3 39
Execute a crystal report from vb2010 3 39
Error when running Crystal Report in BI 2 52
Exclude some records from totals 10 52
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now