LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Combined Table
    • Get a Table from a File
  • Rows
    • Get Rows
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Query a Table
    • Sort a Table
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Input Concepts
  • Output Concepts
  • Examples

Was this helpful?

Export as PDF
  1. Manipulations

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"
Name
Number
Address
City

john

+ 1 (415) 691 9426

123 east street

Santa Clara

joe

+ 1 (415) 691 1234

321 west street

San Jose

jack

+ 1 (415) 691 4595

213 north street

Santa Clara

2. Replace Values in a Sample Integer Table

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

150

10

300

200

5

500

Last updated 23 days ago

Was this helpful?