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
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
234.000 then receiver should get 000234000
Edited by: Harsha reddy on Sep 12, 2008 9:55 PM
Use the following standar functions
Sender field->Multiple by 1000(this will remove the decimal)->formatNum(000000000)->substring("String",3,8)