I have the Data Cleanse tool embedded into another macro that will process files with a multitude of changing text fields. Since the tool exists as a macro, what are the setting modifications to the base actions that would always be defaulting to "All" of those incoming text fields to be selected?
Understood that first dealing with text fields only is accomplished changing the List Box -
Field Type ListBox(11) from the macro
but what are the modifications so that all fields coming into the tool will be utilizing the "All" selection choice as a default? Comments, Ticket Type and Applications Impacted would be a sample of another set of data coming into this tool with these columns not previously seen...
Text fields not selected
It appears that upon the field selection, the IN statement is crafted from the fields that would be manually selected, but I need them to dynamically always select all text fields to be cleansed.
Check Box (109) from the macro
Here is the info on the tool Tool Mastery - Data Cleanse.
Thanks for help on this!