Using Filter() for WildCards

[Rhudi]

I'm sure this has been answered, but I'm not sure how to ask. All the searches I've tried keep giving me "Auto Filter" type answers that are no help.

Here goes... This is what I am trying to do...

I'm using this in some code:

Please Login or Register  to view this content.

I thought I could do this:

Please Login or Register  to view this content.

... and the answer is "Nope. Doesn't work like that."

What I'm trying to do is a partial-match search where the data might be "'... unit 505# '" (there is a space in there, so I won't hit '... unit 505 ', but need to find '... unit 5050 ' to '... unit 5059 ').

I bet this is so simple. :P

[mrice]

The filter function is designed for arrays. Have you considered the Instr function as an alternative for a single string variable?

[Rhudi]

UIPAddress is an array.
Initially, it will have all the interfaces lines from a Juniper router dump.
What I'm doing with the filter is just being left with only the lines that match my text. I've been doing exact matching just fine this way.

Now, I want to be able to partial-match.

[romperstomper]

Filter returns an array of the strings that contain the substring you specified. You don't need wildcards. For example:

Please Login or Register  to view this content.

[Rhudi]

That doesn't work for my situation.
If I have an array that contains:
...
"505 "
"...
"5050 "
"5051 "
"5059 "
...

If I'm looking for all the 505x (but not the 505), I'd want to search for "505? ".

I suppose that I could filter, then length match and drop the items that aren't the correct length.

[romperstomper]

It's either that or loop through all the items.