Wild Card in filters

Put your best Excel related tips and tricks here.
Forum rules
This is the place to put all of your Excel Tips & Tricks.
EricPZ
Posts: 2
Joined: Wed Oct 22, 2014 12:26 pm

Wild Card in filters

Postby EricPZ » Fri Mar 13, 2015 6:31 am

Does this error message mean that you can't include wildcards in filters using a web service connection? It runs fine when connecting directly to SQL.
Attachments
error.jpg

JET-btr
Posts: 164
Joined: Thu Jun 19, 2014 4:09 pm

Re: Wild Card in filters

Postby JET-btr » Thu Apr 02, 2015 11:23 am

You should still be able to do a wild card filter but I can't really make out what your actual filter value is. It could just be a syntax error. It looks like your filter is "WI*.."

What is the function you are using and what is the filter value?

EricPZ
Posts: 2
Joined: Wed Oct 22, 2014 12:26 pm

Re: Wild Card in filters

Postby EricPZ » Fri Apr 03, 2015 6:56 am

Thanks for responding.

The filter is (or rather should be) "WI*..WI*" I wanted to give the customer the ability to select a range or just repeat the wildcard. It works fine when I run it in my environment but errors when I run it on the customers site.

rmw
Posts: 139
Joined: Fri Jun 26, 2009 5:46 am

Re: Wild Card in filters

Postby rmw » Sat Apr 04, 2015 12:09 pm

You state it is going ok with an SQL datasource and not with a webservice datasource.

What about applying the last remark in the error message: If the value 'WI*' was intended to be a wildcard, enclose the value in single quotes.
Did you do that?

It sounds counter intuitive, because using single quotes makes the search literal.
But it seems the way to go for webservices.

HTH

rmw


Return to “Excel Tips & Tricks”

Who is online

Users browsing this forum: No registered users and 1 guest