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

x
?
Solved

I  want  to  exclude  values  which  contains  string  which has "<"

Posted on 2015-01-29
2
Medium Priority
?
114 Views
Last Modified: 2016-02-17
Here  DTQCResult  is  a  DataTable.
Some  time  it  happens  that  ResultValue comes  as ">50" or "<40" etc  so  I  want  to  exclude  those  values  which contains operators ">" or "<". I  was  successful  in  exclusing  ResultValue  that  comes  "NA". Please  help.
Following is  line  where  I  have  to  do  it.So  that  in  deSelectect  does  not  have  values  with ">" or this "<"

DataRow[] drSelectect = DTQCResult.Select("CheckCol=1 AND ResultValue <> 'NA'");

Open in new window


Please  it little  bit  urgent
0
Comment
Question by:ADITYA RAO
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40577189
HI,

pls try

DataRow[] drSelectect = DTQCResult.Select("CheckCol=1 AND ResultValue <> 'NA'" AND ResultValue NOT LIKE '*<*' AND ResultValue  NOT LIKE '*>*'");



Regards
0
 

Author Closing Comment

by:ADITYA RAO
ID: 40577204
Thank you very  much  it  worked  perfectly
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

580 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