salesforce Dreamforce On-Demand
Contact Us 1-800-596-4880
  1. Homepage
  2. RPA Builder (6.6)
  3. Toolbox
  4. Variable Handling

  5. String Operations

String Operations

The String Operations action step enables you to modify strings by using several operations, including find and replace and trimming.

Properties

  • Input Text

    The string that you want to modify.

    Specify this value manually or use the wizard to define this value via the pin variable.

  • Use a regular expresion for string to find

    Select this option to evaluate the value specified in the Find what field in the wizard (StringToFind variable) as a regular expression and apply the regex to the Input Text.

    This option is valid only when using the string operation Find and replace text.

Inbound Variables

  • Input Text

    The string that you want to modify.

    Specify this value manually or by using the wizard to select a pin variable for the value.

  • StringToFind

    The string to search for inside the Input Text string.

  • StringToReplaceWith

    The string to replace the found instances of StringToFind.

  • CharacterToTrimAt

    The character to use as delimiter when using trim operations.

  • NumberOfCharacters

    The number of characters to count when using trim operations.

Outbound Variables

  • Result

    The modified string is output as the result. You can then use this string in later action steps.

  • Result Length

    The length of the modified result string.

  • Start Index

    The index of the first character of a substring that is found during the operation.

  • End Index

    The index of the last character of a substring that is found during the operation.

  • Match Count

    The numbers of substrings found during the operation.

Wizard

Use the Wizard to select the string operation to perform, the input text to analyze, and any other necessary parameters depending on the operation you select. Available operations are:

Analyse

Outputs the length of the specified input text string.

Find and replace text

Searches and replaces text found in the input text. For example:

  • Input text (string) = MyTESTString

  • Find what = TEST

  • Replace with = NEW

  • Output = MyNEWString

Left (take first characters)

Outputs the specified number of characters from the string, starting from the first character. For example:

  • Input text (string) = MyTESTString

  • Number of characters = 4

  • Output = MyTE

Right (take last characters)

Outputs the specified number of characters from the string, starting from the last character. For example:

  • Input text (string) = MyTESTString

  • Number of characters = 4

  • Output = ring

Trim left (remove first characters)

Removes the specified number of characters from the string, starting from the first character. For example:

  • Input text (string) = MyTESTString

  • Number of characters = 3

  • Output = ESTString

Trim right (remove last characters)

Removes the specified number of characters from the string, starting from the last character. For example:

  • Input text (string) = MyTESTString

  • Number of characters = 3

  • Output = MyTESTStr

Takes first characters of the string until a specific character (specific character is not part of output)

Outputs all characters between the beginning of the string and the first occurrence of the Character to trim at value. For example:

  • Input text (string) = MyTESTString

  • Character to trim at = t

  • Output = MyTESTS

    The output string does not include the search character.

Takes last characters of the string until a specific character (specific character is not part of output)

Outputs all characters between the last occurrence of the Character to trim at value and the end of the string. For example:

  • Input text (string) = MyTESTString

  • Character to trim at = T

  • Output = String

    The output string does not include the search character.

Removes first characters of the string until a specific character (specific character is not part of output)

Removes all characters between the beginning of the string and the first occurrence of the Character to trim at value. For example:

  • Input text (string) = MyTESTString

  • Character to trim at = T

  • Output = ESTString

    The search character is removed from the output string.

Removes last characters of the string until a specific character (specific character is not part of output)

Removes all characters between the last occurrence of the Character to trim at value and the end of the string. For example:

  • Input text (string) = MyTESTString

  • Character to trim at = T

  • Output = MyTES

    The search character is removed from the output string.

Reverse string

Reverses and outputs the input string in the existing Result outbound variable. For example:

  • Input text (string) = This is a test string

  • Output = gnirts tset a si sihT

Uppercase conversion

Converts all characters to uppercase. For example:

  • Input text (string) = my test string

  • Output = MY TEST STRING

Lowercase conversion

Converts all characters to uppercase. For example:

  • Input text (string) = MY TEST STRING

  • Output = my test string

Find and return index of string found

Searches for a substring within the input string and outputs the index where the substring is found. You can use a regular expression to define the substring to search. For example:

  • Input text (string) = My test string

  • Find what = test

  • Output = 4

    If the substring is not found, the output result is 0. If the regular expression is invalid, the action step is set to error state.