topic Why does Search & Replace not work for JMP19? in Discussions

Why does Search & Replace not work for JMP19?

pcarroll1 — Thu, 15 Jan 2026 22:24:36 GMT

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.

Re: Why does Search & Replace not work for JMP19?

txnelson — Thu, 15 Jan 2026 23:15:13 GMT

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

support@jmp.com

Re: Why does Search & Replace not work for JMP19?

christian-z — Fri, 16 Jan 2026 15:35:46 GMT

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.

Re: Why does Search & Replace not work for JMP19?

hogi — Fri, 16 Jan 2026 17:18:53 GMT

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

new in JMP19: recode selected columns:

^: prepend
$: append

Re: Why does Search & Replace not work for JMP19?

hogi — Fri, 16 Jan 2026 17:28:41 GMT

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.

Re: Why does Search & Replace not work for JMP19?

pcarroll1 — Mon, 26 Jan 2026 15:57:50 GMT

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 support@jmp.com as @txnelson suggested. In the meantime I'll use JMP18.

Re: Why does Search & Replace not work for JMP19?

pcarroll1 — Mon, 26 Jan 2026 16:00:54 GMT

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 support@jmp.com and will use JMP18 in the meantime.

Re: Why does Search & Replace not work for JMP19?

pcarroll1 — Mon, 26 Jan 2026 16:14:59 GMT

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.

Re: Why does Search & Replace not work for JMP19?

hogi — Mon, 26 Jan 2026 17:12:17 GMT

@pcarroll1 wrote:

Also, I did not find "Formula Column".

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