Discussions
Solve problems, and share tips and tricks with other JMP users.
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.
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
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.
Wonderful trick !
Thanks for "developing it via the community".
new in JMP19: recode selected columns:
^: prepend
$: append
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.