on 11-02-2008 9:26 AM
Hi
Is there a standard function for extracting last digits of a field value?
Thanks
Hi,
use substring function.
Thanks,
Madhav
Note: Points If Useful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Pratichi,
I don't believe there is any standard function. You need to write simple UDF in order to achieve it. Like below sample code...
String ret = a.substring(a.length()-4, a.length();
return ret;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.