cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
vitali_pom
Level I

JSL - How to remove formula from column?

Hi,

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

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: JSL - How to remove formula from column?

Below is another option:


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


:Time << Delete Formula;


Wendy

View solution in original post

5 REPLIES 5
Jeff_Perkinson
Community Manager Community Manager

Re: JSL - How to remove formula from column?

Try the  Delete Property() message to the column.


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



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


-Jeff

-Jeff

Re: JSL - How to remove formula from column?

Below is another option:


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


:Time << Delete Formula;


Wendy
lwx228
Level VIII

Re: JSL - How to remove formula from column?

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

Re: JSL - How to remove formula from column?

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

txnelson
Super User

Re: JSL - How to remove formula from column?

Or by using the :Name() function form

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