topic How do I Script to Change Selected Column Names in Discussions

How do I Script to Change Selected Column Names

ShahirahLoqman — Thu, 13 Dec 2018 12:28:58 GMT

Hi, is there a script for me to select the last 10 columns in my table (the ones after "Transition?") and add ".Cv" at the end of the original column name?

I tried writing my script but it did not work:

dt = Current Data Table();

ColList = dt << get column names( string );

For( i = 11, i <= N Items( ColList ), i++, // set which column that look sat grade spec limits

NewName << ColList[i] || ".Cv";

Column( dt, ColList[i] ) << Set Name(NewName);

);

Thanks!

Re: How do I Script to Change Selected Column Names

txnelson — Thu, 13 Dec 2018 12:40:16 GMT

Here is a simplified version of your code that will add ".Cv" to the end of the specified columns

dt = Current Data Table();
 
For( i = 11, i <= N Cols( dt ), i++, 
 
	Column( dt, i ) << Set Name( (Column( dt, i ) << Get Name) || ".Cv" );
 
);

Re: How do I Script to Change Selected Column Names

ShahirahLoqman — Thu, 13 Dec 2018 14:44:59 GMT

It works! Thank you so much !

Re: How do I Script to Change Selected Column Names

wrubi — Thu, 13 May 2021 10:28:19 GMT

somehow old but still good ;) ... thank you