on 12-17-2010 3:05 PM
Hi Experts,
I have a mapping requirement in which I need to map a source field with a target field in which I need to strip off the leading say 4 zeros from the target field. Now, can this be done with standard PI functions available or we need an UDF for this functionality.
Please let me know.
Regards,
Aniruddha
Hi Aniruddha,
You can do it with the standard function formatNumber.
Also, you can write a custom UDF with the following code:
String ret = a.replaceFirst("^0+","");
return ret;
Best regards,
JN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jose,
I will try out the UDF as well.
Thanks for your help once again.
Regards,
Aniruddha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jose,
Thanks a lot for your help again, I was trying a UDF as an option.
Regards,
Aniruddha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.