topic Re: Renaming a column in Discussions

Renaming a column

asvp — Tue, 21 Dec 2010 17:33:26 GMT

I am trying to rename a column using the following script but it does not work, can anyone tell me what is wrong with this script? are there better ways to rename columns?

col2 = Column(2);
col2 = Set Name ("XYZ");

Thanks.

Re: Renaming a column

pmroz — Tue, 21 Dec 2010 17:53:35 GMT

You're close. Try this instead:

col2 = Column(2);
col2 << Set Name ("XYZ");

Re: Renaming a column

asvp — Tue, 21 Dec 2010 19:11:14 GMT

Thanks....that works.

Re: Renaming a column

jorgeramosdealm — Tue, 29 Jan 2013 21:28:15 GMT

You can also use munger to change part of the name of a column. This is useful after "tabulate" or "summary" specially if you iterate through the different variables.

eg one variable

column(data_table,2)<<set name(munger(munger(eval(char(column(data_table,2))),1,"Column(\!"text_that_you_want_to_change ",""),1,")\!")",""));

eg all variables

for(i=1,i<=n col(data_table),i++,

column(data_table,i)<<set name(munger(munger(eval(char(column(data_table,i))),1,"Column(\!"text_that_you_want_to_change ",""),1,")\!")","")));