# mapping issue

I am idoc to file scenario.

my requirement is ,

I have a quantity field.which is of length 15from IDOC.it has got 3 decimals.which means that last 3 digits are decimals

now my requirement is....

I need to take 6 digits before the decimal and 3 decimals and send it to the receiver.Total receiver field length is 9.At receiver we dont need to have decimal

For eg:

If we get 123456.789 from sender..then the should be sent as 123456789

If we get 123456789012.345 then this should be sent as 789012345

what should be done...any UDF..if so can i get the code....

One more thing is that,If we get 234.000 then we need to add zero infront and sent to Receiver

for eg:

234.000 then receiver should get 000234000

Edited by: Harsha reddy on Sep 12, 2008 9:55 PM

##### Aamir Suhail replied

Hey

Use the following standar functions

Sender field->Multiple by 1000(this will remove the decimal)->formatNum(000000000)->substring("String",3,8)

Thanx

Aamir