Mapping Level query

[Former Member]

Hi all ,

One feild data coming as 10- .Now user expecting the sign should come in front . expecting result is -10 ..

Kindly help how to resolve in mapping level ..

Regards,

Azmath.

[Former Member · Accepted solution]

I have tried replace value .. But the values are coming randomly ..Please any one help on this ..

Regards,

Azmath.

[Snavi · Accepted solution]

Hi Shaik,

you can use udf

if( var.charAt( var.length()-1)=='-' )
{
  var = '-' + var.substring(0,var.length()-1);
}


return var;

[Former Member · Accepted solution]

Hi Navdeep ,

Thanks for your reply ..

Is there any chance to use in the mapping level ... Client not accepting to use any swing ,Nwds .. extra tools...

If any chance to do in the mapping level ...

Regards,

Azmath.

[former_member237514 · Accepted solution]

Hi Shaik,

That udf is in mapping level only.apply and config like below.

source field---udf--target field.

Thanks

Kavitha

[Former Member · Accepted solution]

Thanks alot Navadeep and kavitha ...