The FIND-AND-REPLACE directive transforms string column values using a "sed"-like expression to find and replace text.
Syntax
| Code Block |
|---|
find-and-replace :column <sed-script> |
Usage Notes
This directive is a column-oriented text processor that operates on a single value in the given column. The sed-script is applied on each text value to transform the data.
...
| Code Block |
|---|
find-and-replace :column s/\/usr\/local\/bin/\/common\/bin//g |
Example
Using this record as an example:
...