on 10-08-2015 1:05 PM
Hi,
I have a requirement where data will be sent as "inr" and it needs to be converted to "INR". However, sometimes the same filed might contain other characters like "%".
I know that we can use the Text Function "toUpperCase", however will there be any error when different characters come.
If so, is there any alternative way to convert from lower cases to upper cases and avoid getting an error.
Thanks
Udaya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No Exception will Come for %%^$^%$^%$ etc
There wont be any error if different characters come you can also use the node function for it or String.toUpperCase() is fine.
the special characters will apeear in the final string unchanged
ffff%rrr
output
FFFF%RRR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Udaya,
you need to achieve this via UDFD. Use the function change to upper case and catch the exception in case of other char comes.
If you are sure that only % will come then you can use the replace string to replace it with blank and use the standard function.
changeCase.toUpperCase( );
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
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.