---
title: Substitute
description: Replace one specified string with another
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# Substitute

## Replace one specified string with another

***Function:***

Substitute(table = *string*, cols = *list*, search_for = *string*, replace_with = *string*)

 

***Parameters:***

*Table: *Table name on which to perform function

*Columns:* Range of columns to perform Substitute

*Search For: *Value(s) to find that is to be replaced/substituted

*Replace With: *Value that will replace searched for value(s)

 

***Examples:***

Substitute(table = Budget, cols = ["Geography"], search_for = "USA", replace_with = "United States")