ReplaceFirst
Description
Replaces the first substring of a string that matches the given regular expression with the given replacement. A new column is created for the results.
Use
- Argument:
- Select an argument. (String)
- Regex:
- Enter a regular expression to match with the argument's value.
- Replacement:
- Enter a replacement value for the argument values matching with the regular expression.
- Output field name:
- Enter an output field name.
Example
| Value | RegEx | Replacement | ReplaceFirst() returns |
|---|---|---|---|
| Red Blue Red | Red | Green | Green Blue Red |