Desktop productivity for business analysts and programmers

Filter out Numbers starting with '04'

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

Filter out Numbers starting with '04'

Hi Forum,

I have a table of data that contains a Column of telephone numbers.

I want to filter out any records where the telephone number field has a number beginning with '04'.

So far I've added an Advanced Expression something like the below in SAS EG 4.3.

SUBSTR(TELEPHONE_NO, 1, 2) <> '04'

This doesn't work & changes all telephone nunmbers to a single digit, 0, 1 2 etc.

I'd prefer to add afilter in a Query Builder but there isn't an option to write the above expression...

Can anyone advise how this can be done?

Thanks 


Accepted Solutions
Solution
‎11-26-2013 12:33 AM
Respected Advisor
Posts: 3,825

Re: Filter out Numbers starting with '04'

Not sure about EG 4.3 but in newer versions in the Query Builder you could select as filter operator "Does not match pattern" and as value '04%'

This will translate into SQL:  TELEPHONE_NO NOT LIKE '04%'

View solution in original post


All Replies
Solution
‎11-26-2013 12:33 AM
Respected Advisor
Posts: 3,825

Re: Filter out Numbers starting with '04'

Not sure about EG 4.3 but in newer versions in the Query Builder you could select as filter operator "Does not match pattern" and as value '04%'

This will translate into SQL:  TELEPHONE_NO NOT LIKE '04%'

Frequent Contributor
Posts: 80

Re: Filter out Numbers starting with '04'

Thanks Patrick !

I had tried that using just '04' but didn't think to include the %, DUH ...

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 916 views
  • 0 likes
  • 2 in conversation