Why does Search & Replace not work for JMP19?
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.
Data Blending and CleanupRe: Why does Search & Replace not work for JMP19?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?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?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?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?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?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?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?
@pcarroll1 wrote:
Also, I did not find "Formula Column".
me neither.
Many of Learnbot's creative approaches collide with what is possible in JMP.
