Find or Replace

This activity allows users to search for a specified value in the input datatable and replace it with another value.

Properties

INPUT

Input Datatable: Specifies to provide the input datatable to search within the provided range in the sheet.

Match Case: Ensures that the search matches the case (uppercase or lowercase) of the provided value exactly.

Operation: Specifies the operation to be performed in the Datatable.
Available options:

a. Find:Finds and returns the first matching value.
b. Find All:Finds and returns all matching values.
c. Replace: Finds and replaces the first matching value.
d. Replace All: Finds and replaces all matching values.

Find Value*: Specifies the input value to be searched within the datatable. Accepts values in String datatype.

Replace Value*: Specifies the value to replace the found text with. This parameter is applicable only when Replace or Replace All is selected. Accepts values in String datatype.

Column Names*: Specifies to provide the column name where the operation is to be performed in comma separated values. Accepts values in String datatype.

e.g.( Name, Age, City)

MISC

Display Name: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

Output

Count: Returns the number of matched values found in the input DataTable in type of Int32.

Found Location: Returns the row index or column index where the first matched value is found in String format.

Found Locations: Returns all row or column indexes where the matched values are found in List of String datatype.

Updated Datatable: Returns the output with the updated values in a structured table format.

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.