mapping rule

[Former Member]

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

[GabrielSagaya]

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;

}

[former_member194786]

Hi Sai,

You can use the function formatNum for your requirment.

Thanks and Regards,

Sanjeev.

PS: Award points if helpful

[Former Member]

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