Articles in this section

uppercase helper

Tom Santiago
Updated

Use the uppercase helper to convert all lowercase letters in a given string or field to uppercase characters. This is useful for standardizing text fields (e.g., product categories, usernames) or ensuring uppercase output in flow data.

Usage

{{uppercase field}}

  • field: The text-based field or variable you want to transform (e.g., record.category).

Example

  1. Converting a literal string 

    {{uppercase "library"}}

    Produces "LIBRARY".

  2. Using data from the record 

    The {{uppercase family.type}} is a member of the {{uppercase family.animal}} family

    If family.type is "dog" and family.animal is "canine", the output becomes:

    The DOG is a member of the CANINE family

  3. Triple braces for raw output 

    {{{uppercase record.description}}}

    Returns the uppercase string without Celigo’s automatic formatting.

Tip

  • Non-alphabetic characters and uppercase letters remain unchanged.

  • If the field contains numbers or other symbols, they are unaffected.

  • If the field is empty or null, uppercase returns an empty string.