Uppercase action

The Uppercase action in the String package enables you to convert the source string to uppercase.

Settings

  • In the Source string field, specify the source string.
  • In the Assign the output to variable list, specify the variable.

Example

In this example, you will create an automation to read employee data from an excel sheet and convert an employee name to uppercase. This action enables you to ensure consistency across the dataset for accurate data analysis.

Before you build an automation, create an excel sheet with the following data:
Name Date fo joining
Olivia white 20/09/2024
Liam wenington 11/11/2024
Oliver Wright 24/07/2024
Create an automation and perform the following steps to convert one of the employee names to uppercase:
  1. Create a bot.
    1. On the left panel, click Automation.

      A list of available bots and forms is displayed.

    2. Click Create a bot.
    3. Enter the bot name: String_uppercase.
    4. Click Create and Edit.
  2. Read the data from the excel sheet.
    1. Double-click or drag the Excel advanced > Open action.
    2. In the File field, select the Desktop file: C:\Bot testing\Employee_data.xlsx
    3. Select the Sheet contains a header option.
    4. In the Create Excel session field, enter Default.
    5. Double-click or drag the Excel advanced > Read row action.
    6. From the Cell option field, select the From specific cell option.
    7. Enter A2 in the Cell address field.
    8. Select the Read visible text in cell option.
    9. Retain the Session name as Default.
    10. In the Assign the output to variable field, select the list variable ExcelRowData to store the output.
    11. Double-click or drag the Excel advanced > Close action.
    12. Retain the Session name as Default.
  3. Convert the retrieved value from the excel sheet to a string variable.
    1. Double-click or drag the List > Get item action.
    2. In the List variable field, enter ExcelRowData
    3. In the Index number field, enter 0.
    4. In the Assign the output to variable field, select the string variable string_output to store the output.
    5. To print the values, double-click or drag the Message box action. In the Enter the message to display field, enter $string_output$.

      The bot retrieves the value from the excel sheet and displays the output as follows:

      Retrieved value from the Excel sheet

  4. Convert the retrieved value to uppercase.
    1. Double-click or drag the String > Uppercase action.
    2. In the Source string field, enter $string_output$
    3. In the Assign the output to variable field, select the string variable uppercase_output to store the output.
  5. To print the values, double-click or drag the Message box action. In the Enter the message to display field, enter $uppercase_output$.

    The bot converts the retrieved value to uppercase and displays the output as follows:

    Output of the converted value