nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Why does Search & Replace not work for JMP19?

pcarroll1

JMP19 S&R.jpg

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.

Accepted answers

txnelson

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

hogi

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

new in JMP19: recode selected columns:

^: prepend
$: append

All comments

txnelson

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

christian-z

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.

hogi

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

new in JMP19: recode selected columns:

^: prepend
$: append

hogi

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.

pcarroll1

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.

pcarroll1

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.