Desktop productivity for business analysts and programmers

Filter with Wild Cards

Accepted Solution Solved
Reply
Contributor
Posts: 34
Accepted Solution

Filter with Wild Cards

I have some location codes that may be 3 characters or 5 characters.  Regardless of how many characters, I need a filter set that will return all location codes that begin with the letter "Y".  I've tried 'Contains Y%', with no results.  Can someone suggest the correct syntax? 

 

Thanks, in advance, for your help!

Rita Yee

Project Engineer, FedEx Express

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.

Accepted Solutions
Solution
‎09-27-2017 09:44 AM
Super Contributor
Posts: 344

Re: Filter with Wild Cards

Try:

upcase(substr(locationCode,1,1)) = 'Y'

 

Use it in an advance filter Smiley Happy

//Fredrik

View solution in original post


All Replies
SAS Super FREQ
Posts: 496

Re: Filter with Wild Cards

In what context are you asking?  This will work in some contexts:

 

code =: 'Y'

Solution
‎09-27-2017 09:44 AM
Super Contributor
Posts: 344

Re: Filter with Wild Cards

Try:

upcase(substr(locationCode,1,1)) = 'Y'

 

Use it in an advance filter Smiley Happy

//Fredrik

Contributor
Posts: 34

Re: Filter with Wild Cards

Worked perfectly!! Thanks so much!

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 198 views
  • 0 likes
  • 3 in conversation