message mapping -How to change 1.2345 to 12345

[Former Member]

Hi everybody,

How can I have all the digits of the source field in the target field with the decimal pont removed.

Source field --1.2345

target field --12345

thanks,

Ramya Shenoy

[Former Member · Accepted solution]

HI use standard function REPLACE STRING

or

Multiply the source field with 10000 and use FORMAT NUM function

[former_member859847]

Hi,

Prepare an udf to remove decimal point.

you can use the following java code for udf .

String s1="";

for( int i=0; i<a.length();i++)

{

if (a.charAt(i) == '.') {}

else

s1= s1 +a.charAt(i);

}

return s1;

regards

mahesh

[Former Member]

use replace function in text funtiions......give the input as first parameter,second parameter "." and third parameter ""(nothing just two double quotes).