philologist's techblog

Use case 1:
convert the username consisting of letters in incoming INVITE from your VoIP provider to digits
(e.g. INVITE: rt_user1@192.168.1.203 -> INVITE: 13511654321@192.168.1.203, where country-city-subscriber is 1-3511-654321):

Add to your dialplan table:

INSERT INTO dialplan VALUES \
(1002,0,0,'rt_user1',1,'','13511654321',NULL,0,'modifying letters to digits in provider''s ruri');

So, the SQL record is as follows:

sqlite> select * from dialplan where dpid=1002;
         id = 2
       dpid = 1002
         pr = 0
   match_op = 0    # Matching operator for rule (0-equal, 1-regexp).
  match_exp = rt_user1
match_flags = 1
  subst_exp = 
   repl_exp = 13511654321
    timerec = 
   disabled = 0
      attrs = modifying letters to digits in provider's ruri