https://community.jmp.com/t5/Discussions/how-to-Define-different-data-formats-per-JMP-JSL/m-p/836591#M101336 <P>Most likely you would want to split your table and have different formats in different columns</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1738820839609.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/72548i611DA5548EC508F9/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1738820839609.png" alt="jthi_0-1738820839609.png" /></span></P> <P>Otherwise I think you would have to rely on Best format.</P> <P>&nbsp;</P> <P>Edit:</P> <P>You can read a bit more about numbers/strings in JMP from <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/numbers-and-strings.shtml?" target="_blank" rel="noopener">Scripting Guide</A> and <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/numeric-formats.shtml#ww425352" target="_blank">JMP Help</A> and finally <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/date-and-time-functions.shtml#ww6742865" target="_blank">JSL Syntax reference of Format</A> (note that Format function will return text)</P> Thu, 06 Feb 2025 06:04:10 GMT jthi 2025-02-06T06:04:10Z https://community.jmp.com/t5/Discussions/how-to-Define-different-data-formats-per-JMP-JSL/m-p/836568#M101335 <P>I have two columns in the file, one column is the parameter name, the second column is the parameter value, I want to confirm whether JMP can make a definition: different parameter names corresponding to the parameter value has a different numerical format. For example: the parameter name is TTV is an integer format, and the parameter name is <STRONG>CARRIER CONCENTRATION and </STRONG>RES is a scientific notation.</P> Thu, 06 Feb 2025 04:51:18 GMT https://community.jmp.com/t5/Discussions/how-to-Define-different-data-formats-per-JMP-JSL/m-p/836568#M101335 wenwenzhou 2025-02-06T04:51:18Z https://community.jmp.com/t5/Discussions/how-to-Define-different-data-formats-per-JMP-JSL/m-p/836591#M101336 <P>Most likely you would want to split your table and have different formats in different columns</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1738820839609.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/72548i611DA5548EC508F9/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1738820839609.png" alt="jthi_0-1738820839609.png" /></span></P> <P>Otherwise I think you would have to rely on Best format.</P> <P>&nbsp;</P> <P>Edit:</P> <P>You can read a bit more about numbers/strings in JMP from <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/numbers-and-strings.shtml?" target="_blank" rel="noopener">Scripting Guide</A> and <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/numeric-formats.shtml#ww425352" target="_blank">JMP Help</A> and finally <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/date-and-time-functions.shtml#ww6742865" target="_blank">JSL Syntax reference of Format</A> (note that Format function will return text)</P> Thu, 06 Feb 2025 06:04:10 GMT https://community.jmp.com/t5/Discussions/how-to-Define-different-data-formats-per-JMP-JSL/m-p/836591#M101336 jthi 2025-02-06T06:04:10Z