transformations:massreplace
This is an old revision of the document!
Table of Contents
TABLE-WIDE REPLACE
Category: Transform / Advanced
Description
This action performs the same replacement in all or selected columns.
Use cases
This action is typically used for data cleansing, e.g. for removing the word 'NULL' in all columns.
Action settings
Setting | Description |
---|---|
Search for | Enter the value to search for. |
where it's | Select whether to match whole-cell values, or whole-cell values and partial values. Options: Entire cell only or Entire cell or part of longer text. |
Replace with | Enter the value to replace the search value with. |
which is | Select whether the replacement value will occupy the entire cell or just the matching portion of the found search value. Options: Entire cell or Matching part. |
Perform replacement in | Select whether to search all or specific columns. Options: All columns or Selected columns (and select the column(s) to search from the list). |
Remarks
This action is case-sensitive. If the Search for value does not match values case-wise, the replacement is not made.
Numeric values can only be searched for, and replaced as, entire cell values. Upon entering a numeric value in the Search for field, only the Entire cell only options will be selectable.
Examples
Objective: Replace "North America" or "South America" with simply "America".
Source table: The longest rivers in the world
River | Length (km) | Continent |
---|---|---|
Nile | 6650 | Africa |
Amazon | 6400 | South America |
Yangtze | 6300 | Asia |
Mississippi | 6275 | North America |
Yenisei | 5539 | Asia |
Yellow River | 5464 | Asia |
Ob | 5410 | Asia |
Paraná | 4880 | South America |
Action parameters:
Search for: "America"
where it's: Entire cell or part of longer text
Replace with: "America"
which is: Entire cell
Perform replacement in: All columns
Output table:
River | Length (km) | Continent |
---|---|---|
Nile | 6650 | Africa |
Amazon | 6400 | America |
Yangtze | 6300 | Asia |
Mississippi | 6275 | America |
Yenisei | 5539 | Asia |
Yellow River | 5464 | Asia |
Ob | 5410 | Asia |
Paraná | 4880 | America |
See also
transformations/massreplace.1619634519.txt.gz · Last modified: 2021/04/28 14:28 by dmitry