Hi Team
I am using below expression function in INFORMATICA 9.5 to make initial letters as CAPS .
[INITCAP(IIF(ISNULL(ITEMS),'NA',ITEMS))]
Output :
Before After
APPLICATIONS --> Applications
SP TERMS --> Sp Terms
I want output to be as SP Terms
Please let me know what expression will satisfy my needs .Thanks