Replace Value in Column
- 22 Feb 2024
- 1 Minute to read
- Print
- DarkLight
Replace Value in Column
- Updated on 22 Feb 2024
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Step Details | |
Introduced in Version | 4.0.0 |
Last Modified in Version | 7.12.0 |
Location | Data > Excel & CSV |
The Replace Value in Column step enables you to replace a specific value within a cell, based on the input column of the given Excel file. This step requires you to define the Old Value and the New Value. It will then iterate through the values in the selected column and replace any instances of the Old Value with the New Value.
Important Considerations:
This step does not generate any output. Instead, it modifies the value within the same file that is being used within the Flow.
The values given under the "Old Value" field must be the entire cell value. It will not replace any partial values within the defined cell.
Properties
Inputs
Property | Description | Data Type |
|---|---|---|
File | The Excel or CSV file where the data is pulled from. | FileData |
File Type | The type of file being used by the step. The step currently supports CSV, Excel_xls, or Excel_xlsx. Use Constant mapping to view the drop-down. | CSVFileType |
Worksheet Number | The Worksheet Number to pull the data from. The values start at zero. | Int32 |
Column | The column number of the value to replace. The starting value is one. | Int32 |
Old Value | The old value needs to be replaced. | String |
New Value | The new value to place in the cell. | String |
Converter Flows:
The Old Value and the New Value only accept strings. Users can use Converter Flows to convert them to Number, Text, and Date formats.
Related Information
Was this article helpful?
