https://community.jmp.com/t5/Discussions/Sixth-data-extraction/m-p/707545#M89186 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The Scripting Index is in the Help menu." style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/59501i7FE258229677E9C8/image-size/large?v=v2&amp;px=999" role="button" title="capture.png" alt="The Scripting Index is in the Help menu." /><span class="lia-inline-image-caption" onclick="event.preventDefault();">The Scripting Index is in the Help menu.</span></span></P> Sun, 10 Dec 2023 02:25:52 GMT Craige_Hales 2023-12-10T02:25:52Z https://community.jmp.com/t5/Discussions/Sixth-data-extraction/m-p/707531#M89185 <P>Let say I have data "12345278" and "12345078" and would like to extract out the sixth, any formula I can use?<BR />Coz if use Right(data,3), then the data will be "278" or "078"</P><P>For every sequence have to be extracted out in diff column, so it might be quite inconvenient to use like this: Left(Right(data,3),1)&nbsp;</P><P>Any suggested method to do this?</P> Sun, 10 Dec 2023 01:25:16 GMT https://community.jmp.com/t5/Discussions/Sixth-data-extraction/m-p/707531#M89185 Sysy13 2023-12-10T01:25:16Z https://community.jmp.com/t5/Discussions/Sixth-data-extraction/m-p/707545#M89186 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="The Scripting Index is in the Help menu." style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/59501i7FE258229677E9C8/image-size/large?v=v2&amp;px=999" role="button" title="capture.png" alt="The Scripting Index is in the Help menu." /><span class="lia-inline-image-caption" onclick="event.preventDefault();">The Scripting Index is in the Help menu.</span></span></P> Sun, 10 Dec 2023 02:25:52 GMT https://community.jmp.com/t5/Discussions/Sixth-data-extraction/m-p/707545#M89186 Craige_Hales 2023-12-10T02:25:52Z https://community.jmp.com/t5/Discussions/Sixth-data-extraction/m-p/708055#M89223 <P>Thank you!</P> Mon, 11 Dec 2023 23:58:08 GMT https://community.jmp.com/t5/Discussions/Sixth-data-extraction/m-p/708055#M89223 Sysy13 2023-12-11T23:58:08Z