Replace Value in a Column

Replaces occurrences of a value in a table.

Overview

This procedure finds and replaces all instances of a value within a specific table column. It helps keep your data clean and consistent by automatically replacing all matching values in the selected column.

Input Concepts

Concept	Type	Description	Default	Required
table	table	The table to perform the replacement in.	No default	Yes
column	text	The name of the column to perform replacement in.	No default	Yes
value	text/number/date	The value to be replaced.	No default	Yes
replacement	text/number/date	The value to replace with.	No default	Yes

Output Concepts

Concept	Description
table	The updated table.

Examples

1. Replace Values in a Specific Column of a Sample Table

Automation

create a sample table
replace "San Jose" in the table's "City" column where
    the replacement is "Charlotte"

Results

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

2. Replace Values in a Specific Column of a Sample Integer Table

Automation

create an integer table
replace 300 in the table's "Max" column where
    the replacement is 150

Results

Amt	Min	Max
100	10	150
200	5	500