Skip to Content
avatar image
Former Member

Lower case to upper case

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 08, 2015 at 12:32 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 08, 2015 at 12:27 PM

    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( );

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 08, 2015 at 03:02 PM

    Hello Udaya,

    No error will come if you touppercase.see the below example.


    Capture.JPG (57.2 kB)
    Add comment
    10|10000 characters needed characters exceeded