Choose Language Hide Translation Bar
Highlighted
Rajat
Level IV

Find and Delete all formulas present in a table

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: Find and Delete all formulas present in a table

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

View solution in original post

1 REPLY 1
Highlighted
txnelson
Super User

Re: Find and Delete all formulas present in a table

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

View solution in original post

Article Labels

    There are no labels assigned to this post.