BookmarkSubscribeRSS Feed

Community Trekker


Feb 13, 2017

Choose Language Hide Translation Bar

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.


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




Article Labels
Article Tags