Tech Togs

 Tableau converting text case  UPPER case function lower case function Proper case function UPPER case function : The upper case function converts all letters to uppercase (capital letters) ex: Function  Name : UPPER (Name) Result: Name: AJAY KUMAR lower case function : The lower case function converts all letters to lowercase.(small letters) ex: Function Name: LOWER(Name) Result: Name: ajay kumar Proper Case The Proper case is text that is capitalized with the first letter of each word. ex: Create a calculator field for this: Name UPPER(LEFT(SPLIT([Name],' ',1),1)) + LOWER(MID(SPLIT([Name],' ',1),2,20)) + ' ' + UPPER(LEFT(SPLIT([Name],' ',2),1)) + LOWER(MID(SPLIT([Name],' ',2),2,20)) + ' ' + UPPER(LEFT(SPLIT([Name],' ',3),1)) + LOWER(MID(SPLIT([Name],' ',3),2,20)) Result: Name: Ajay Kumar