---
title: Text Cleanup
description: Format text columns; trim, fill blanks, text case adjustments
---

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

# Text Cleanup

## Format text columns; trim, fill blanks, text case adjustments

***Function:***

Text_Cleanup(table = *string*, cols = *list*, l_strip = *boolean*, r_strip = *boolean*, fill_blank = *boolean*, format_text = *boolean, *format* = drop down*)

 

***Parameters:***

*Table: *Table name on which to perform function

*Columns to clean:* Select the Column to Clean

*Remove Left leading characters:* Remove blank characters on the Left

*Remove Right leading characters:* Remove blank characters on the Right

*Fill Blanks: *Fill blank values

*Format: *True or False, if True a drop down for Case type will appear

*Text Formatting: *Only will appear if Format = True. Options are; Lower Case, Upper Case, Proper Case

 

***Examples:***

Text_Cleanup(table = Sales_Commish_Detail, cols = ["Company","Product"], l_strip = True, r_strip = True, fill_blank = True, format_text = True, format = "Proper Case")