Upper/Lower Case
Converts a string to all uppercase, all lowercase, or proper case (where the first letter of each word is capitalised).
Excel
Upper: =~UPPER!~(‹string›)
Lower: =~LOWER!~(‹string›)
Proper: =~PROPER!~(‹string›)
=UPPER(A1) // "Main1234" -> "MAIN1234"
=LOWER(A2) // "Id0001" -> "id0001"
=PROPER(A3) // "DIV HR OPS" -> "Div Hr Ops"
Tableau
Upper: ~UPPER!~(‹string›)
Lower: ~LOWER!~(‹string›)
UPPER([Cost Centre]) // "Main1234" -> "MAIN1234"
LOWER([ID code]) // "Id0001" -> "id0001"
NB. Proper/Title case is not available as a standard calculation in Tableau. The only workaround (other than manipulating the data at source, which is preferable) is to split out the value using space characters as delimiters, slice the first character from each string and convert it to upper case, then recombine all string fragments:
IFNULL(UPPER(LEFT([Name],1)) + LOWER(MID([Name],2,FINDNTH([Name]," ",1)-1))
+ UPPER(MID([Name],FINDNTH([Name]," ",1)+1,1)) + LOWER(MID([Name],FINDNTH([Name]," ",1)+2,LEN([Name]))),"")
Alteryx
Upper: ~UPPERCASE!~(‹string›) Lower: ~LOWERCASE!~(‹string›) Proper: ~TITLECASE!~(‹string›)
UPPERCASE([Cost Centre]) // "Main1234" -> "MAIN1234"
LOWERCASE([ID code]) // "Id0001" -> "id0001"
TITLECASE([Business Unit]) // "DIV HR OPS" -> "Div Hr Ops"
OrgVue
Upper: ‹string›.value.~toUpperCase()!~
Lower: ‹string›.value.~toLowerCase()!~
node.costcentre.value.toUpperCase() // "Main1234" -> "MAIN1234"
node.id.value.toLowerCase() // "Id0001" -> "id0001"
NB. Proper/Title case is not available as a standard calculation in OrgVue. The only workaround (other than manipulating the data at source, which is preferable) is to split out the value using space characters as delimiters, slice the first character from each string and convert it to upper case, then recombine all string fragments.
array(node.name.value.split(' '))
.map(i=>[
i.value.slice(0,1).toUpperCase(),
i.value.slice(1).toLowerCase()
].join(''))
.join(' ')
tSQL
Upper: ~UPPER!~(‹string›) OR ~UCASE!~(‹string›)
Lower: ~LOWER!~(‹string›) OR ~LCASE!~(‹string›)
SELECT UPPER(CostCentre) AS CostCode
FROM ProductsData
SELECT LOWER(ID) AS Identifier
FROM OrdersData
Python
Upper: ‹string›.~upper()!~
Lower: ‹string›.~lower()!~
Proper: ‹string›.~title()!~
costCentre.upper() # "Main1234" -> "MAIN1234"
id.lower() # "Id0001" -> "id0001"
businessUnit.title() # "DIV HR OPS" -> "Div Hr Ops"
NB. The above examples assume variables have been declared for costCentre
, id
and businessUnit
. For more information, go to General > Variables.
Last updated
Was this helpful?