https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856448#M102709 <P>I would assume so. It can be at least found from JMP17 help <A href="https://www.jmp.com/support/help/en/17.2/#page/jmp/recode-data-in-a-column.shtml#ww1042951" target="_blank">https://www.jmp.com/support/help/en/17.2/#page/jmp/recode-data-in-a-column.shtml#ww1042951</A> </P> Thu, 27 Mar 2025 21:19:31 GMT jthi 2025-03-27T21:19:31Z https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856435#M102706 <P>Hi - can someone help me with a solution for removing the second hyphen in the 1st row in the "Number" column below?</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dn610_0-1743108537077.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/74316i70D6BE21274C24CE/image-size/medium?v=v2&amp;px=400" role="button" title="dn610_0-1743108537077.png" alt="dn610_0-1743108537077.png" /></span></P> <P>&nbsp;</P> Thu, 27 Mar 2025 20:50:45 GMT https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856435#M102706 dn610 2025-03-27T20:50:45Z https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856446#M102707 <P>Have you tried playing around with Recode? </P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1743108854908.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/74317i6F78B9B4D14E9B51/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1743108854908.png" alt="jthi_0-1743108854908.png" /></span></P> <P>Formula like</P> <PRE><CODE class=" language-jsl">Word([1 -1], :Column 1, "-")</CODE></PRE> <P>might also work (and there are plenty of other options).</P> Thu, 27 Mar 2025 20:56:33 GMT https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856446#M102707 jthi 2025-03-27T20:56:33Z https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856447#M102708 <P>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?</P> Thu, 27 Mar 2025 21:13:25 GMT https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856447#M102708 dn610 2025-03-27T21:13:25Z https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856448#M102709 <P>I would assume so. It can be at least found from JMP17 help <A href="https://www.jmp.com/support/help/en/17.2/#page/jmp/recode-data-in-a-column.shtml#ww1042951" target="_blank">https://www.jmp.com/support/help/en/17.2/#page/jmp/recode-data-in-a-column.shtml#ww1042951</A> </P> Thu, 27 Mar 2025 21:19:31 GMT https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856448#M102709 jthi 2025-03-27T21:19:31Z https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856515#M102713 <P>I see it now. Thank you!</P> Fri, 28 Mar 2025 01:18:08 GMT https://community.jmp.com/t5/Discussions/Removing-punctuation-in-a-string/m-p/856515#M102713 dn610 2025-03-28T01:18:08Z