Replace a Value

Replaces occurrences of a value in a table.

Overview

This procedure finds and replaces all instances of a specific value within a table. It can be used to update outdated information, correct mistakes, or standardize values across rows—like changing all instances of "Pending" to "In Progress," or replacing a misspelled name.

Input Concepts

Concept
Type
Description
Default
Required

table

table

The table to perform the replacement in.

No default

Yes

value

string/number/date

The value to be replaced.

No default

Yes

replacement

string/number/date

The replacement or new value.

No default

Yes

Output Concepts

Concept
Description

table

The updated table.

Examples

1. Replace Values in a Sample Table

create a sample table
replace "San Franciso" in the table where
    the replacement is "Santa Clara"

2. Replace Values in a Sample Integer Table

create an integer table
replace 100 in the table where
    the replacement is 150

Last updated

Was this helpful?