Why does Search & Replace not work for JMP19?

[#1]

Above is a picture of an attempt to Search for the beginning of the line of the 3 Column Names and Replace that with the prefix "Pre-" in JMP19.  it causes my computer to start calculating who-knows-what for more than 20 minutes, before I finally decided to kill it.  My computer heats up, the fan comes on and it sounds like it's in distress!  I have to do something similar to this almost every day and have never had a problem in previous versions of JMP, where it usually finishes instantly.  Is this a bug in JMP19?  It is unusable to me if this is not fixed.

[#2 · Accepted solution]

I have replicated your finding.  After clicking on Replace All, it popped up the Replacing Data window.  I waited a short bit of time and then Cancelled the operation, only to have a JMP Alert window pop up stating that over 21 million occurrences had been replaced. 

Since I was only Searching on column names, and it was supposed to be restricted to the 2 selected columns, I think this is truly a bug.

Please report this to

     [email protected]

[#3]

Have you tried using Column Names -> Recode Column Names? It works just like Recode, so you can Replace String using regular expressions. It is working for me using "^" to insert at the beginning of the column name, in JMP 19.0.3. 

[#4 · Accepted solution]

Wonderful trick !
Thanks for "developing it via the community".

new in JMP19: recode selected columns:

^: prepend
$: append

[#5]

creative approach by the #Learnbot - almost worth a submission to the wish list:

maybe oldname as a universal variable for the column name,
allowing actions like Word(1,oldname),  Left(oldname, 5), ...
and the described concatenation.

[#6]

Thanks for the suggestion.  I showed a grossly simplified table, compared to what I normally work with.  Many of my tables have thousands or 10s of thousands of columns, so renaming manually one by one is not an option.   Certainly, I can write JSL code to do this.  But S&R is a Windows standard forever and should work in JMP19.  I have alerted  [email protected] as @txnelson suggested.  In the meantime I'll use JMP18.

[#7]

Also, I did not find "Formula Column".  I did find "Replace String", which allowed S&R on multiple columns.  This worked.  A bit mor work that a straight S&R but at lease it works.

[#8]

---

@pcarroll1 wrote:

Also, I did not find "Formula Column".

---

me neither.
Many of  Learnbot's creative approaches collide with what is possible in JMP.

[#9]

Thank You for the suggestion.  I often want to rename thousands or 10s of thousands of columns.  S&R should work as it has up to JMP18.  It's a bug that needs to be fixed.  I contacted [email protected] and will use JMP18 in the meantime.