Find and Delete all formulas present in a table

[#1]

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 :)

[#2 · Accepted solution]

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 )
);