Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
how to find and replace all instances of specified characters within a given column
Mar 13, 2020 11:10 AM(1596 views)
This is a very simple question. I have a given column in a JMP table, and I want a JMP scripting command that will find and replace all instances of specified characters within that column. For example, I have a column called GROUP, and certain rows in GROUP contain values like "A05 or "B17 and I would like to replace all " characters in GROUP so that the entries become A05 and B17 instead of "A05 and "B17. This can easily be done manually by going to Table - Search - Find and then doing a find and replace, but is there a simple way to script this?
Thanks for that reply. Maybe I am mistaken, but I thought Recode can be used to replace entire, known values with different values. But in my case, to be more specific, the values of GROUP can be like "A05, or "B17, or anything of the form "***, where all I know is that the value starts with a " character and then the * characters are wildcards which could be anything. Really all I want to do is just strip the " out of the values.