Documentation

Remove Comma Operation: removecomma

The removecomma operation under the String Operations function is used to remove all commas from a given string. This operation is particularly useful for cleaning numeric data or preparing strings for processing where commas might cause errors or inconsistencies.

Example: Suppose you have a string “1,234,567” that represents a number with commas for formatting. You want to remove the commas and store the cleaned value in a variable named CleanedNumber.

Steps to Configure:

1. Add a new step.
2. Select Set a Variable Value from the Action dropdown.
3. Enter a variable name in the Element Key field (e.g., CleanedNumber). This variable will store the string without commas.
4. Click on Form, select Functions, and choose String Operations.
5. Provide the following parameters:
   • Operation: Choose removecomma.
   • Data: Enter the string with commas to be cleaned (e.g., “1,234,567”).
6. Click Save.

Outcome on Execution

• The operation removes all commas from the string.
• The updated string (“1234567“) is stored in the variable defined in the Element Key field (e.g., CleanedNumber).
• This variable can be referenced in subsequent automation steps using the syntax ${VariableName} (e.g., ${CleanedNumber}).