[DRILL-3490] initcap function creates invalid data on all uppercase data

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.1.0
• Fix Version/s: Future
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Uwe Geercken
• Created: 13/Jul/15 06:59
• Updated: 01/Oct/15 16:38

Description

the INITCAP function capitalizes the first character of each word in a given string.

when the given string is already all uppercase, INITCAP produces an invalid result.

Example:

from the value = HELSINKI-VANTAA AIRPORT
the INITCAP function returns: H%,3).+)-V!.4!! A)20/24

a workaround that does work is to first use the LOWER function:

INITCAP(LOWER(<value>))