script to find and replace portions of character entries in a column
May 15, 2020 7:48 AM(289 views)
In my data table, I have a column of data type Character with a column name of Size. The entries for the different rows in column Size are like 8 or so different variations of things like sglLrg500, sglLrg800, sglLrg150, etc. I would like to have a JMP script that can quickly replace sgl in each of the entries in Size with Sgl instead, so that sglLrg500 for example would become SglLrg500.
I could do this manually by selecting the Size column then selecting Edit, Search, Find, and then set Find What to sgl and Replace With to Sgl and check the box for "Restrict to selected columns" and the click Replace All. But I would like if possible a simple JMP script to do the same thing. Thanks.