BookmarkSubscribe
Choose Language Hide Translation Bar
MarkDayton
Community Trekker

Find & Replace for Column Names

Saving report output to a data table often creates long column names that become cumbersome in subsequent analyses. This is a stupid little script to replace/remove text from the names of selected columns.

 

Usage: select the columns you want to modify, run the script, enter the text that needs to be changed (including spaces), and then enter the text to change it to (again including spaces, leave blank to replace with nothing).

 

Obviously if there are no open data tables, the script does nothing. If there are no columns selected, i.e.there aren't any columns identified as needing change, the script currently does nothing, though a prompt to select columns could be added.

 

Update: The first selected column name is included in the text box to make it easier to indicate the text to be found

Comments
galactus3000

thank you for posting ... is their a way to make this an add-in?

MarkDayton

Done.

 

Article Labels
Article Tags
Contributors