on 04-04-2007 2:40 PM
Hi Experts,
Iam new to XI.
Iam doing a File to Idoc scenario (PO Response) ,
I want to remove the leading zeroes from one of the field from file and map it to the corresponding Idoc field.
Is there any Standard functions to do this ? If not , Can anyone pls post the code for UDF to execute this Logic.
waiting for ur response.
Thanks in Advance.
Regards
Krupa.
Hi,
The Function Round ( under Arithmetic ) might help you, Check it out
Regards
Agasthuri Doss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you donot need a UDF for this....
use the 'formatNum' function in the arithmetic functions....as a parameter to this function just put '#'...
This will suppress all the leading zeroes...
Thanks,
Renjith
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
say ur inptu to the udf is <b>inputVal</b> use the below code in UDF:
String output = <b>inputVal</b>.replaceFirst("^0+","");
return output;
or also
int Seq = Integer.parseInt(<b>inputVal</b>)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.