What database are you using?
You could do this with regular SQL, but it would by a costly operation,
for PostgreSQL we're using the prefix module: http://pgfoundry.org/projects/prefix/
You can then match the closest prefix by using something like
"WHERE myprefix_col @> caller_destination_number ORDER BY LENGTH
(myprefix_col::text) LIMIT 1;"
Best regards,
Even André
> _______________________________________________
On 13. okt. 2009, at 23.53, Diego Viola wrote:
> Hello,
>
> I'm trying to write a post-paid billing script, I have the CDR on my
> database and also a "rates" table, the CDR contains fields like
> caller_destination_number, variable_duration, etc. and the rates
> table contains: destination, prefix, rate (cost).
>
> The problem is that I can't just strip the destination number to
> take the prefix from it because I have to deal with destination
> numbers from different countries and they all have different prefix
> lengths... so I need to find another way to take the prefix from the
> destination number.
>
> Any ideas how to do this?
>
> Thanks,
>
> Diego
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-
> users
> http://www.freeswitch.org
_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org