---
title: Mid
description: Substring from middle of column string
---

[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)

# Mid

## Substring from middle of column string

***Function:***

Mid(table = *string*, col = *string*, left_start = *integer*, right_start = *integer*)

 

***Parameters:***

*Table: *Table name on which to perform function

*Column Name(col):* Column to perform Mid

*Left On: *Number of Charters to look Left

*Right On: *Number of Charters to look Right

 

***Examples:***

Mid(table = Budget, col = Geo, left_start = 2, right_start = 5)