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

Saving the prediction formula to an existing column?

Hi,

I'm a new JMP user. I have several prediction formula saved to columns, and other columns linked to those. Now I want to update the formulas (many) in the original prediction columns with the new regression formula. Saving the prediction formula seems only possible to a new appended column. I suppose I could copy the formula from the new column and paste into the original column, but it's tedious. Perhaps the whole thing can be scripted, like excel's macro recorder??

Anyway, thanks in advance :)
Dave
11 REPLIES 11

Re: Saving the prediction formula to an existing column?

xan-

Using Concat(a,b), what kind of quoting do I need to append the following to a string?

"MxBmin","[kNm]","=

...of course, the quotes are confusing the concat() function :(
XanGregg
Staff

Re: Saving the prediction formula to an existing column?

If you're trying to embed double quotes in a string, you can escape them with the two characters \! . For example:

s = "text with \!"quotation marks\!".";