Skip to main content

查找替换工具

使用查找替换工具在数据集的一列中查找字符串，并在找到后将其替换为另一个字符串。您还可以使用“查找替换”将列附加到行。

工具组件

“查找替换”工具有两个锚点：

  • F input anchor: This input is the initial input table ("F" for "Find"). This is the table that is updated in the tool's results.

  • R input anchor: This input is the lookup table ("R" for "Replace"). This is the table that contains data used to replace data in (or append data to) the initial input.

  • 输出锚点：输出锚点显示“查找替换”工具的结果。

配置工具

“查找替换”工具配置有 3 个部分：查找表、查找和替换。

查找部分

  1. 选择搜索条件：

    • 包含：在列的任何部分搜索列值的实例。整个列不必只包含搜索内容。

    • 开头为：在列的开头搜索列值的实例。整个列不必只包含搜索内容。

    • 完全等于：搜索整个列中包含的列值的实例。实例必须完全匹配整个列，才能替换为新值。

  2. Column to Search: Select the column from the F input anchor with the data that you want to replace.

  3. Find Value: Select the column from the R input anchor that contains the data you want to search for in the Column to Search.

  4. 选择可选的搜索条件：

    • 区分大小写：此选项将在搜索中包含大小写。

    • 仅当全字匹配：仅当有前后空格时才能匹配字符串。如果字符串于位于单元格的开头或末尾，其另一端必须有一个空格。

Replace Section

You can choose to replace data using these options...

  • Replace Found Text

    1. Choose this option to replace the found text with the text in the Replace Value column (from the R input anchor).

    2. Optionally select Replace All Matched Items. Only use this if you selected Contains from the Search Criteria option.

  • Create Columns with Replace Data

    1. Choose this option to create a column populated with the lookup table (R input anchor) data whenever the selected Find Values data is found within the selected Column to Search.

    2. Check the columns you want to create.