Analytics Software

Hi All,

I have requirement to convert the column values(Data in the Columns) from upper case to camel case in pivot table view.

For Eg:

I have

Table Name:Billing_Transaction
under Billing_Transaction table i Have column Comment_Text
Data in Comment_Text Column is

INSERT,
EXPORT,
AMEND



How i will change these values in to Insert,Export,Amend.(Camel Case condition)

I want only the first letter of a word to be in caps and others to be in smaller case.


Thanks,

Chitra Subramani.