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

Automation

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

Results

Name	Number	Address	City
john	+ 1 [phone]	123 east street	Santa Clara
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	Santa Clara

2. Replace Values in a Sample Integer Table

Automation

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

Results

Amt	Min	Max
150	10	300
200	5	500