asterisk users - May 2010 - Working with Blacklist database

I have an Asterisk 1.4.2 system online and have built up quite a large 
blacklist of tele-spammers that have been calling us.  Recently we 
swapped one of our DID numbers to a SIP provider that now prefixes all 
calls with +1xxxxxxxxxxxx in front of US numbers (we're in the USA) and 
I need to edit my blacklist database so that all numbers in there that 
don't have the +1 prefix in front of them, now have a version of it that 
can match to these new prefixes.

Or alternatively I need to change my Dialplan to search for a match 
against the Blacklist database on a substring of the incoming caller ID.

Has anyone done this before?  Is it easy to edit the content of the 
Blacklist database like in a SQL database, where I can simply insert new 
records based on the old records but change the prefix to them with the +1?

Myles
-- 
-----------------------------
Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
Scottsdale, Arizona USA
www.techsolusa.com
Phone +1-480-451-7440

> I have an Asterisk 1.4.2 system online and have built up quite a large 
> blacklist of tele-spammers that have been calling us.  Recently we 
> swapped one of our DID numbers to a SIP provider that now prefixes all 
> calls with +1xxxxxxxxxxxx in front of US numbers (we're in the USA) and
> I need to edit my blacklist database so that all numbers in there that 
> don't have the +1 prefix in front of them, now have a version of it
that
> can match to these new prefixes.
Just remove the +1:

exten => xxx/_+1.,1,Set(CALLERID(num)=${CALLERID(num):2})

Where xxx is the relevant extension.