- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How do I Script to Change Selected Column Names
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!
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I Script to Change Selected Column Names
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" );
);
Jim
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I Script to Change Selected Column Names
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" );
);
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I Script to Change Selected Column Names
It works! Thank you so much !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How do I Script to Change Selected Column Names
somehow old but still good ... thank you