cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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\!".";