Removing punctuation in a string

[#1]

Hi - can someone help me with a solution for removing the second hyphen in the 1st row in the "Number" column below?

[#2 · Accepted solution]

Have you tried playing around with Recode?

Formula like

Word([1 -1], :Column 1, "-")

might also work (and there are plenty of other options).

[#3]

Thank you! I did look into recode, but I didn't see the options that you're seeing. Is that extract segment popup available in JMP 17?

[#4]

I would assume so. It can be at least found from JMP17 help https://www.jmp.com/support/help/en/17.2/#page/jmp/recode-data-in-a-column.shtml#ww1042951

[#5]

I see it now. Thank you!