In this guide covering wildcard filtering, we will be looking at using wildcard filtering to report on telephone numbers that contain a sequence of digits anywhere in the number.
The below Akixi report displays a log of historic calls – the ‘TELNO (CLG)’ field displays the external telephone numbers that have called in and the ‘TELNO (CLD)’ field displays the internal telephone numbers that have been called. We are going to use wildcard ‘contains’ filtering to filter on just the telephone numbers that contain the digits ’02’.
Filtering on digits:
To do this, modify the report and insert *02* into the ‘Telephone No(s)’ field. When it comes to using wildcard containing, an asterisk character will need to be positioned either side of the digits that are being used to search and filter on. In this case 02.
Once you have clicked ‘OK’, you will see that the report will filter on just the telephone numbers that contain the digits ’02’.
Excluding on digits:
You can also use wildcard contains filtering to exclude telephone numbers that contain a sequence of digits anywhere within the number.
To do this, modify the report and insert !*02* into the ‘Telephone No(s)’ field. Using the same method as before, you will just need to insert the exclamation mark at the start before the first asterisk character.
Once the report filter settings have been saved, all of the numbers that contain the digits specified will be excluded from the report (in this case ’02’):
Click here for more information on wildcard filtering.