[2008] Wildcards?

[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

[.paul.]

you've found them

[Deathader]

No, what I need is like:

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

[joe1985]

No, what I need is like:

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

You'll want to use a regular expression.

[.paul.]

You'll want to use a regular expression.

how about an example?

[joe1985]

how about an example?

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

[Deathader]

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

How would I use regex as a wild card?

[.paul.]

edit

[Deathader]

edit

Do you mind giving me an example?

[alex_read]

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!

[agent]

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