¶ Description
This action removes a specific prefix string from selected column values.
¶ Parameters
Parameters:
-
Columns to process:
Select one or more columns whose values may contain the prefix. -
Prefix to remove:
Specify the prefix string to be removed from the beginning of the column values.
¶ About
The Remove Prefix action is useful when working with standardized naming conventions or imported data that include technical prefixes (e.g., Prefix_, col_, tmp_, etc.). By cleaning these up, your data becomes easier to read, process, or export.
This action only removes the prefix if it exists at the start of the value. If the value does not begin with the prefix, it is left unchanged.
¶ Example
Column: C1
Value: Prefix_Data
Configuration:
- Prefix to remove:
Prefix_
Result:
Column: C1
Value: Data
See the following screenshot for an example:
Note
Combine this with Remove Suffix or Rename Column for advanced cleanup tasks.
