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