[2008] Wildcards?

Well, what I'm looking for are 3 different wild cards I can use while searching a textbox.

Here's an example of what I need:

? Matches any single character at the position. For example, the expression "ABCDE" Like "AB?DE" returns True because it matches any character in the third position of the string as long as the remaining characters match exactly.

* Matches zero or more characters at the position. For example, the expression "ABCDE" Like "*CDE" returns True because it matches any characters at the beginning of the string followed by "CDE" at the end of the string. Likewise, "ABCDE" Like "AB*" returns True since the two strings begin with "AB" irrespective of any following characters. The expression "ABCDE" Like "*D*" returns True because the string contains "D" preceded and followed by any number of characters.

^ Matches zero or more integers at the position. For example, the expression "12345" Like "^345" returns True because it matches any integers at the beginning of the string followed by "345" at the end of the string. Likewise, "12345" Like "12^" returns True since the two strings begin with "12" irrespective of any following integers. The expression "12345" Like "*4*" returns True because the string contains "4" preceded and followed by any number of integers.

# Matches any single digit (0 - 9) at the position. For example, the expressions "12345" Like "12#45" and "12845" Like "12#45" return True because they match any decimal digit in the third position of the string as long as the remaining characters match exactly.

Please respond asap :)
Thanks,
Alex

you've found them

No, what I need is like:

Code:

---

if instr(textbox1.text, "11758##49#") then
listbox1.items.add("Found!")
end if

---

Quote:

---

Originally Posted by Deathader

No, what I need is like:

Code:

---

if instr(textbox1.text, "11758##49#") then
listbox1.items.add("Found!")
end if

---

---

You'll want to use a regular expression.

Quote:

---

Originally Posted by joe1985

You'll want to use a regular expression.

---

how about an example?

Quote:

---

Originally Posted by .paul.

how about an example?

---

http://www.google.com/search?q=regular+expression

Quote:

---

Originally Posted by joe1985

http://www.google.com/search?q=regular+expression

---

How would I use regex as a wild card?

edit

Quote:

---

Originally Posted by .paul.

edit

---

Do you mind giving me an example?

There are some examples here: http://www.regular-expressions.info/quickstart.html and I'd suggest taking a look at the Wrox book "beginning Javascript" which has a great chapter on regular expressions. They aren't for the feint of heart and knocking up a simple sample for your above problem isn't a 2 second job - it could turn into a few hours work and involve pulling lots of hair out!

Quote:

---

Originally Posted by Deathader

Well, what I'm looking for are 3 different wild cards I can use while searching a textbox.

Here's an example of what I need:

? Matches any single character at the position. For example, the expression "ABCDE" Like "AB?DE" returns True because it matches any character in the third position of the string as long as the remaining characters match exactly.

* Matches zero or more characters at the position. For example, the expression "ABCDE" Like "*CDE" returns True because it matches any characters at the beginning of the string followed by "CDE" at the end of the string. Likewise, "ABCDE" Like "AB*" returns True since the two strings begin with "AB" irrespective of any following characters. The expression "ABCDE" Like "*D*" returns True because the string contains "D" preceded and followed by any number of characters.

^ Matches zero or more integers at the position. For example, the expression "12345" Like "^345" returns True because it matches any integers at the beginning of the string followed by "345" at the end of the string. Likewise, "12345" Like "12^" returns True since the two strings begin with "12" irrespective of any following integers. The expression "12345" Like "*4*" returns True because the string contains "4" preceded and followed by any number of integers.

# Matches any single digit (0 - 9) at the position. For example, the expressions "12345" Like "12#45" and "12845" Like "12#45" return True because they match any decimal digit in the third position of the string as long as the remaining characters match exactly.

Please respond asap :)
Thanks,
Alex

---

Though several other responses indicate using regex, in this case, you're probably better off using the Like operator. You should look it up in the vb help but it basically works like this:

"abc" Like "a*" = True
"abc" Like "a?" = False