Need to trim leading digits for DB Lookup - UCCX 7

[michael_cole]

Currently have a UCCX script that will be performing a DB lookup based on ANI, however, I've noticed that when my ANI comes in it is prefaced with a "91".  Rather than try and reconfigure what the gateway is accepting, I am wondering if it is possible to strip those 2 digits with Java language before sending it into the DB Read step using a Set command...I'm not too familiar with Java coding...Is this possible?

Thanks

[Aaron Harrison · Accepted solution]

Hi

You can insert some Java for this... try something like this in a 'do' step (yourvariable swapped for your string var name containing ANI):

{
     if (yourvariable.startsWith("91"){
          return = yourvariable.substring(2,yourvariable.length());
     }
}

Aaron

[brian1mcc]

put your ani in a variable called AniStr and use the following in your set step

AniStr.substring(2)

Brian

edit - or what Aaron says

[michael_cole]

Thanks to both of you...will use Brian's in the event all numbers come in with "91" prepended and jump to Aaron's if they do not

[Vinod Patil]

Hi Michael, I have task to write a script for DB lookup based on ANI, no idea how to start the script if you have similar script could you please help me? Thanks and best regards, Vinod