Find and Delete all formulas present in a table

Rajat — Sun, 19 Apr 2020 17:11:08 GMT

Hi,

I have 1000 columns in a table with 500 columns have formulas. I want to write a jsl script which will find the column having formula and delete the formula. One line code is highly recommended.

Thanks :)

Re: Find and Delete all formulas present in a table

txnelson — Sun, 19 Apr 2020 18:28:28 GMT

Interactively you can do this with the Standardize Attributes dialog, but if you want a script

Names Default To Here( 1 );
dt = Current Data Table();
numCols = dt << get column names( numeric );
For( i = 1, i <= N Items( numCols ), i++,
	Try( Column( dt, numCols[i] ) << delete formula )
);

and if you want a one line script

Names Default To Here( 1 );dt = Current Data Table();numCols = dt << get column names( numeric );For( i = 1, i <= N Items( numCols ), i++,Try( Column( dt, numCols[i] ) << delete formula ));

It is possible to shorten it down but make the script work a little longer

For( i = 1, i <= N cols(current data table()), i++,
	Try( Column( i ) << delete formula )
);

topic Find and Delete all formulas present in a table in Discussions

Find and Delete all formulas present in a table

Re: Find and Delete all formulas present in a table