topic How to replace specific words in multiple column names? in Discussions

How to replace specific words in multiple column names?

UserID16644 — Thu, 05 Sep 2024 02:47:25 GMT

Hi all,

Is it possible to replace the column names which contains a specific word? For example, my column names are Name, Age, New_Address, New_School, New_Number. And I need to replace the word New with Current or columns that may contain the word New ---- my new column names will become Name, Age, Current_Address, Current_School, Current_Number. TIA

Re: How to replace specific words in multiple column names?

txnelson — Thu, 05 Sep 2024 03:17:40 GMT

Here is one way to do it

Names Default To Here( 1 );
dt = Current Data Table();
colNames = dt << get column names( string );

For Each( {col}, colNames,
	If( Contains( col, "New" ),
		Column( dt, col ) << set name( Substitute( col, "New", "Current" ) )
	)
);

Re: How to replace specific words in multiple column names?

jthi — Thu, 05 Sep 2024 05:32:50 GMT

You can also use Recode Column Names for this.