Skip to Content
avatar image
Former Member

mapping rule

Hi,

i have one issue on mapping rule. Please give me solution for the below mapping rule.

Remove leading +67(0) to leave just 0

thanks in advance

sai

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 06, 2008 at 11:10 AM

    Hi,

    U always have 67 zeros and then values, if yes then u can use substring function and start from the value which u wanted at the output.

    can u give some example with values.

    chirag

    Add comment
    10|10000 characters needed characters exceeded

  • May 06, 2008 at 11:11 AM

    Hi Sai,

    You can use the function formatNum for your requirment.

    Thanks and Regards,

    Sanjeev.

    PS: Award points if helpful

    Add comment
    10|10000 characters needed characters exceeded

  • May 06, 2008 at 12:03 PM

    you can use UDF also

    function myudf(String a, Container container)

    {

    NumberFormat formatter = new DecimalFormat("0");

    String s = formatter.format(Integer.parseInt(a));

    return s;

    }

    Add comment
    10|10000 characters needed characters exceeded