topic Re: JSL - How to remove formula from column? in Discussions

JSL - How to remove formula from column?

vitali_pom — Sun, 13 Jul 2014 08:27:05 GMT

Hi,

How can I remove a formula from a column without changing it through JSL?

Thanks.

Jeff_Perkinson — Sun, 13 Jul 2014 13:49:49 GMT

Try the Delete Property() message to the column.


dt = Open( "$SAMPLE_DATA/Tiretread.jmp" );


:Pred Formula ABRASION << delete property(Formula);

-Jeff

Wendy_Murphrey — Wed, 16 Jul 2014 14:24:37 GMT

Below is another option:


dt = Open( "$SAMPLE_DATA/Bank Loan.jmp" );

:Time << Delete Formula;

lwx228 — Sun, 19 Aug 2018 10:00:58 GMT

I just found it at this BBS:
Column(dt, "Values From Formula") << deleteFormula;

Zahti — Thu, 12 Mar 2020 19:52:50 GMT

This is perfect for column names that have special characters in them, thanks!!

txnelson — Thu, 12 Mar 2020 22:22:27 GMT

Or by using the :Name() function form

:Name("Values From Formula") << deleteFormula;