Extracting String Match from Like Operator?

Question

2.00/5 (3 votes)

See more:

Hello all,

I just found the handy operator Like to search for keywords in a string. Now, if there is a match, how would I extract just that match?

Say my string is

"A01B01 - My Stuff"

I can see that the string has A01B01 in it by using strMine Like "A##B##". It returns true. But how can I easily extract that info? I need some way to extract the A01B01 from that string. Also, the string can be "01x01" or "01-01" or any combination there of. I can find what type it is. I just test for every single combination and store the "A##B##" or what not in a string. But again, I need to extract that info.

I am betting there is a pretty easy way to do it but for the life of me I can't figure it out.

Thanks!

Posted 3-Mar-11 19:15pm

JBenhart

Add a Solution

Comments

Prerak Patel 6-Mar-11 12:15pm

Try to learn some regex, or I would show you how to do it tomorrow. Don't put your comments as answers.

Prerak Patel 6-Mar-11 22:37pm

Check the updated answer.

2 solutions

Solution 1

You can use Regular expression

A(\d{2})B(\d{2})

VB

Public Function getDimention(ByVal input As String) As String
  Dim returnValue As String = ""
  Dim regex As New RegularExpressions.Regex("A(\d{2})B(\d{2})")
  Dim m As RegularExpressions.Match = regex.Match(input)
  If m IsNot Nothing Then
    returnValue = m.Groups(1).Value & "x" & m.Groups(2).Value
  End If
  Return returnValue
End Function

Posted 3-Mar-11 19:34pm

Prerak Patel

Updated 6-Mar-11 16:37pm

v2

Comments

Ali Al Omairi(Abu AlHassan) 5-Mar-11 7:35am

JBenhart said: "Can you elaborate? I don't know that much about that. "

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sreejith Gopinathan · Accepted Answer · 2011-03-03T21:14:00

Solution 3

This is how you can use Regular expression. Import the below namespace.

C#

System.Text.RegularExpressions;

You can extract the string like

C#

string output = string.Empty;

if(Regex.IsMatch("A01B01 - My Stuff", @"A01B01"))
{
     output = Regex.Match("A01B01 - My Stuff", @"A01B01").Value;
}

Posted 3-Mar-11 21:14pm

Sreejith Gopinathan

Updated 3-Mar-11 21:16pm

v2

Comments

JBenhart 4-Mar-11 20:03pm

But the numbers 01 (and 01) are unknown. I am using strMyString Like "A##B##" to see if it exists. Is there a way to use a wildcard with Regex.match?

Would:
output = Regex.Match(strMyString, @"A[0-9][0-9]B[0-9][0-9]").Value;
work?