You could create new column using Regex or Substitute
Names Default To Here(1);
str1 = "NLTEE(+.98)LAGLDE(+28.99)T(+10.98)IAK";
str2 = "SYELPDGQV(+.98)I(+10.98)T(-17.03)IGNER";
Show(Regex(str1, "[^ABCDEFGHIJKLMNOPQRSTUVWXYZ]", "", GLOBALREPLACE));
Show(Regex(str2, "[^ABCDEFGHIJKLMNOPQRSTUVWXYZ]", "", GLOBALREPLACE));
This assumes that you want to only keep the letters. You can build it for example by using Recode
![jthi_0-1695827659613.png jthi_0-1695827659613.png](https://community.jmp.com/t5/image/serverpage/image-id/57038i9184E19D20B8E6E1/image-size/medium?v=v2&px=400)
and you can use regular expressions with search also
![jthi_1-1695827740130.png jthi_1-1695827740130.png](https://community.jmp.com/t5/image/serverpage/image-id/57039i03E7D09A2B67014B/image-size/medium?v=v2&px=400)
Edit:
Better regex is most likely something like this
Names Default To Here(1);
str1 = "NLTEE(+.98)LAGLDE(+28.99)T(+10.98)IAK";
str2 = "SYELPDGQV(+.98)I(+10.98)T(-17.03)IGNER";
res1 = Regex(str1, "\(.*?\)", "", GLOBALREPLACE);
res2 = Regex(str2, "\(.*?\)", "", GLOBALREPLACE);
show(res1, res2);
-Jarmo