This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Course Of The Month
8 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Help with partial string search
Posted on 2013-01-08
I am using the code below to select rows in a Grid where values of SDeactivation is found agains SDéactivation_ID which is in Coumn(2). SDeactivation_ID contains single values.
When SDeactivation is a single value all is working of but when SDeactivation includes multiple values (i.e. 1,2,3) it does not work. How do i modify the code to select rows when using multiple values for SDeactivation?
MsgBox("keySDeactivation)"
' keySDeactivation = "1,2" does not works
' keySDeactivation = "1" works
If keySDeactivation <> "" Then
Dim _tableA As DataView = dtMasterA.DefaultView
C1SDeactivation.DataSource
For i As Integer = 0 To C1SDeactivation.RowCount - 1
If C1SDeactivation.Columns(2)
C1SDeactivation.SelectedRo
End If
Next
End If
Thanks,
Victor
When SDeactivation is a single value all is working of but when SDeactivation includes multiple values (i.e. 1,2,3) it does not work. How do i modify the code to select rows when using multiple values for SDeactivation?
MsgBox("keySDeactivation)"
' keySDeactivation = "1,2" does not works
' keySDeactivation = "1" works
If keySDeactivation <> "" Then
Dim _tableA As DataView = dtMasterA.DefaultView
C1SDeactivation.DataSource
For i As Integer = 0 To C1SDeactivation.RowCount - 1
If C1SDeactivation.Columns(2)
C1SDeactivation.SelectedRo
End If
Next
End If
Thanks,
Victor
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
- +1
7 Comments
Active today
So your cell value contains a single value such as 1 or 2...
in other words, you can have
C1SDeactivation.Columns(2)
or C1SDeactivation.Columns(2)
etc...
And you are comparing that to keySDeactivation where you can have
keySDeactivation = 1
keySDeactivation = 2
keySDeactivation = "1,2"
etc..
Am I understanding that correctly?
<< If C1SDeactivation.Columns(2)
If so, I think your Contains statement is backwards.
Try rewriting it like this:
in other words, you can have
C1SDeactivation.Columns(2)
or C1SDeactivation.Columns(2)
etc...
And you are comparing that to keySDeactivation where you can have
keySDeactivation = 1
keySDeactivation = 2
keySDeactivation = "1,2"
etc..
Am I understanding that correctly?
<< If C1SDeactivation.Columns(2)
If so, I think your Contains statement is backwards.
Try rewriting it like this:
If keySDeactivation.Contains(C1SDeactivation.Columns(2).CellValue(i).ToString()) = True Then
To make sure that 1 does not match with 11 using Contains function, I would add commas at start and end of the keySDeactivation and do following comparison
Outside loop:
keySDeactivation = "," & keySDeactivation & ","
Inside Loop:
If keySDeactivation.Contains(
Outside loop:
keySDeactivation = "," & keySDeactivation & ","
Inside Loop:
If keySDeactivation.Contains(
Active today
You could use regular expressions:
Imports System.Text.RegularExpressions
...
If Regex.IsMatch(C1SDeactivation.Columns(2).CellValue(i).ToString(), "\b" + keySDeactivation + "\b") Then
C1SDeactivation.SelectedRows.Add(i)
End If
...
Active 2 days ago
Yes, that is ok, those are just values of the ID fields I will use to select the rows.
Thanks.
Victor
Thanks.
Victor
Featured Post
Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month8 days, left to enroll
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.