Bit of a strange one for you. I have a large list of mobile telephone numbers and would like to put the network next to each mobile number.
I have a list of all prefixes for mobile networks in the UK and want to use this to lookup the prefix and determine the network.

I need the output of the list to look like this:
07900123123,Vodafone
07901123123,Vodafone
07903123123,T-Mobile
07906123123,T-Mobile
07908123123,T-Mobile
07909123123,Vodafone
07910123123,T-Mobile

The problem I have is that:
a) I can't work out how to get textpipe to lookup the prefix and then append the respective network
b) I've made a work around by extracting each of the netwok's ranges of prefixes into seperate files - thereby having one file with just the o2 prefixes, one file with just Orange prefixes etc. Then I run a "Special>Retain lines>Retain lines from list" filter individually against each of the network prefix files and thereby matching lines with the relative prefix and then saving these files seperately. This works to some degree, but if you look at the prefix list above you'll see that for example T-Mobile has all prefixes beginning 0790 EXCEPT those beginning 07900, 07901 and 07909 which are Vodafone. Therefore if Textpipe matches 0790 it'll flag this as T-Mobile and export to T-Mobile, without realising that it should be Vodafone.

This would then work in the way described above (Match pattern from list).

I can then use a filter to match against pattern list from file for say o2, then make a subfilter to add text side by side and add ,o2 to the end, then move to the next filter to match against pattern list from file for orange, then make a subfilter to add text side by side etc etc.