Inbound CID Mapping - Non-numeric characters

[Mhojo_NZ]

Is there an easy way to map all non-numeric characters in the in-bound callerid? I have an SQL script that routes calls based on the caller id but is failing whenever the callerid is anything other than a number string. (Some of these are arriving as long character strings, something which I am in discussion with my SIP provider about). I want to map any caller id other than a number. I could map the entire alphabet I guess, but that would result in 26 incoming rules.

 

[leejor]

There is a numeric field (should be strictly numeric), and the name field (alpha-numeric). Are they trying to send a name in the number field? Who is the SIP provider?

 

[Mhojo_NZ]

I either get a number or 'anonymous' when using the session.ani variable in the call flow designer. I thought I was getting other characters as well but I think I misread the logs. Provider is Vocus New Zealand (effectively same as 2Talk).

 

[leejor]

Perhaps someone, using the same provider, can offer some assistance.