cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-524266%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%EC%9D%B4%EC%A7%84%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EC%97%AC%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%A0%A4%EB%A9%B4%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%ED%95%B4%EC%95%BC%20%ED%95%A9%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524266%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%EC%95%88%EB%85%95%ED%95%98%EC%84%B8%EC%9A%94!%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%EC%98%88%EB%A5%BC%20%EB%93%A4%EC%96%B4%20%EC%9D%B4%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EB%A9%B4%20%EC%B2%AB%20%EB%B2%88%EC%A7%B8%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EA%B0%80%20%EB%82%A0%EC%A7%9C%EC%9D%B8%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%AC%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222022-07-21_12-05-43.png%22%20style%3D%22width%3A%20752px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-21_12-05-43.png%22%20style%3D%22width%3A%20752px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44169i5DFF1324E54D2A72%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222022-07-21_12-05-43.png%22%20alt%3D%222022-07-21_12-05-43.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EC%9D%B4%20%22A2%203F%2032%2001%22%EC%9D%84%20%EC%B6%94%EC%B6%9C%ED%95%98%EB%A0%A4%EB%A9%B4%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%ED%95%B4%EC%95%BC%20%ED%95%A9%EB%8B%88%EA%B9%8C%3F%3CBR%20%2F%3E%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%ED%95%B4%EB%8B%B9%2010%EC%A7%84%EC%88%98%20%EA%B0%92%EC%9D%B8%2020070306%EC%9D%84%20%EA%B3%84%EC%82%B0%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%B4%EC%9A%94!%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-524266%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%EC%9E%90%EB%8F%99%ED%99%94%20%EB%B0%8F%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%ED%92%88%EC%A7%88%20%EB%B0%8F%20%EA%B3%B5%EC%A0%95%20%EC%97%94%EC%A7%80%EB%8B%88%EC%96%B4%EB%A7%81%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%EC%9C%88%EB%8F%84%EC%9A%B0%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524361%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524361%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CUL%3E%3CLI%3E%3CP%20class%3D%22%22%3E%EC%A2%8B%EC%95%84%EC%9A%94%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%20class%3D%22%22%3E%EB%B0%A9%EA%B8%88%20%EC%9E%98%EB%AA%BB%EB%90%9C%20%EC%BD%94%EB%93%9C%EB%A5%BC%20%EC%9E%91%EC%84%B1%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%B4%EC%9A%94!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524337%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524337%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%EC%96%B4%EB%96%BB%EA%B2%8C%2016%EC%A7%84%EC%88%98%20%ED%98%95%EC%8B%9D%EC%9C%BC%EB%A1%9C%20%EB%AC%B4%EC%96%B8%EA%B0%80%EB%A5%BC%20%EC%B7%A8%ED%95%98%EC%97%AC%20%EB%B6%80%EB%8F%99%20%EC%86%8C%EC%88%98%EC%A0%90%EC%9C%BC%EB%A1%9C%20%EA%B3%84%EC%82%B0%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E~D9~40~D9~CE%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%EB%8B%A4%EC%9D%8C%20%EC%BD%94%EB%93%9C%EA%B0%80%20%EC%9E%98%EB%AA%BB%20%EC%8B%A4%ED%96%89%EB%90%98%EC%97%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Eb%20%3D%20Char%20To%20Blob(%20%22~D9~40~D9~CE%22%2C%20%22ascii~hex%22%20)%3B%0Af%20%3D%20Blob%20To%20Matrix(%20b%2C%20%22float%22%2C%204%2C%20%22little%22%2C%204%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%B4%EC%9A%94!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524332%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524332%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%ED%96%89%EC%9A%B4%EC%9D%84%20%EB%B9%8C%EC%96%B4%20%EC%9A%94%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524330%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524330%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EA%B3%A0%EB%A7%88%EC%9B%8C%EC%9A%94!%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%EC%98%88%2C%20Craige%EC%97%90%EC%84%9C%20%EC%9D%B4%20%EC%BD%94%EB%93%9C%EB%A5%BC%20%EB%B0%9B%EC%95%98%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%EC%9D%B4%20%EC%BD%94%EB%93%9C%EB%8A%94%20%EC%9D%B4%EC%A7%84%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EA%B5%AC%EC%A1%B0%EB%A5%BC%20%EC%95%8C%EA%B3%A0%20%EC%9E%88%EC%9D%84%20%EB%95%8C%20%EC%9C%A0%EC%9A%A9%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%ED%95%98%EC%A7%80%EB%A7%8C%20%EC%9D%B4%20%EC%83%88%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EA%B5%AC%EC%A1%B0%EB%A5%BC%20%EB%AA%A8%EB%A5%B4%EA%B2%A0%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%20%ED%80%98%EC%8A%A4%ED%8A%B8%EB%A5%BC%20%EC%A7%84%ED%96%89%20%EC%A4%91%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%EC%9D%B4%20%ED%8C%8C%EC%9D%BC%EC%9D%84%2000%20%EA%B0%84%EA%B2%A9%EC%9C%BC%EB%A1%9C%20%EB%9E%98%ED%95%91%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%20%EB%82%98%EB%8A%94%20%EC%9D%B4%EA%B2%83%EC%97%90%20%EB%8C%80%ED%95%9C%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EC%96%BB%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%EB%82%B4%EA%B0%80%20%EC%95%84%EB%8A%94%20%EC%B2%AB%20%EB%B2%88%EC%A7%B8%20%EC%A4%84%EC%9D%84%20%EC%A0%9C%EC%99%B8%ED%95%98%EA%B3%A0%EB%8A%94%20%EB%82%A0%EC%A7%9C%EA%B0%80%20%ED%8F%AC%ED%95%A8%EB%90%98%EC%96%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%EA%B7%B8%EB%9F%AC%EB%82%98%20%EB%91%90%20%EB%B2%88%EC%A7%B8%20%EC%A4%84%EC%97%90%EC%84%9C%20%EC%8B%9C%EC%9E%91%ED%95%98%EB%8A%94%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%8A%94%20%EC%A0%95%EC%88%98%20%EB%8D%B0%EC%9D%B4%ED%84%B0%2C%20%EB%B6%80%EB%8F%99%20%EC%86%8C%EC%88%98%EC%A0%90%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%20%EA%B7%B8%EB%9F%AC%EB%82%98%20%EC%96%B4%EB%96%A4%20%ED%95%84%EB%93%9C%EA%B0%80%20%EB%B6%80%EB%8F%99%20%EC%86%8C%EC%88%98%EC%A0%90%20%EB%98%90%EB%8A%94%20%EC%A0%95%EC%88%98%EC%9D%B8%EC%A7%80.%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%20%EB%AA%A8%EB%A5%B4%EA%B2%A0%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222022-07-21_14-28-39.png%22%20style%3D%22width%3A%20253px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-21_14-28-39.png%22%20style%3D%22width%3A%20253px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-21_14-28-39.png%22%20style%3D%22width%3A%20253px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-21_14-28-39.png%22%20style%3D%22width%3A%20253px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44173i7ED4351B1820ACCB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222022-07-21_14-28-39.png%22%20alt%3D%222022-07-21_14-28-39.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%ED%95%84%EB%93%9C%EB%B3%84%EB%A1%9C%20%EB%B9%84%EA%B5%90%20%ED%95%84%EB%93%9C%EB%A7%8C%20%EB%B3%B5%EC%9B%90%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%EB%82%98%EB%8A%94%20%EC%95%84%EC%A7%81%20%EA%B7%B8%EA%B2%83%EC%9D%84%20%EC%9D%B4%ED%95%B4%ED%95%98%EC%A7%80%20%EB%AA%BB%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524308%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524308%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EA%B7%80%ED%95%98%EC%9D%98%20%EC%BD%94%EB%93%9C%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ebb%20%3D%20Load%20Text%20File(%20%22I%3A%5CE%5C00820070306.zst%22%2C%20blob()%20)%3B%0Aymd%20%3D%20Blob%20To%20Matrix(%20bb%2C%20%22uint%22%2C%204%2C%20%22little%22%2C%208%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E10%EC%A7%84%EC%88%98%20%EA%B0%92%EC%9C%BC%EB%A1%9C%20%EB%B3%80%ED%99%98%EB%90%9C%20%EA%B0%92%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%22ymd%22%EB%9D%BC%EA%B3%A0%20%EB%B6%80%EB%A5%B4%EB%8A%94%202%EC%B0%A8%EC%9B%90%20%ED%96%89%EB%A0%AC%EC%9D%84%20%EB%A7%8C%EB%93%AD%EB%8B%88%EB%8B%A4.%EC%83%88%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84%20%EB%A7%8C%EB%93%A0%20%EB%8B%A4%EC%9D%8C%20%EC%83%88%20%EC%97%B4%EC%9D%84%20%EB%A7%8C%EB%93%A4%EA%B3%A0%20%EC%83%88%20%EC%97%B4%EC%9D%98%20%EA%B0%92%EC%9D%84%20%ED%96%89%EB%A0%AC%20ymd%EC%9D%98%20%EC%B2%AB%20%EB%B2%88%EC%A7%B8%20%EC%97%B4%EB%A1%9C%20%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0%EB%A7%8C%20%ED%95%98%EB%A9%B4%20%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0A%0Abb%20%3D%20Load%20Text%20File(%20%22I%3A%5CE%5C00820070306.zst%22%2C%20blob()%20)%3B%0Aymd%20%3D%20Blob%20To%20Matrix(%20bb%2C%20%22uint%22%2C%204%2C%20%22little%22%2C%208%20)%3B%0A%0Adt%20%3D%20New%20Table(%20%22zst%22%20)%3B%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%20%22col%201%22%20)%3B%0A%20Column(%20dt%2C%201%20)%20%26lt%3B%26lt%3B%20set%20values(%20ymd%5B0%2C%201%5D%20)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%EA%B7%B8%EB%9F%B0%20%EB%8B%A4%EC%9D%8C%20%ED%96%89%EB%A0%AC%EC%9D%98%20%EB%82%98%EB%A8%B8%EC%A7%80%207%EA%B0%9C%20%EC%97%B4%EC%97%90%20%EB%8C%80%ED%95%B4%20%EB%B0%98%EB%B3%B5%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_0-1658383099652.png%22%20style%3D%22width%3A%20722px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1658383099652.png%22%20style%3D%22width%3A%20722px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1658383099652.png%22%20style%3D%22width%3A%20722px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1658383099652.png%22%20style%3D%22width%3A%20722px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44171i3503D043A03BC5CC%2Fimage-dimensions%2F722x531%3Fv%3Dv2%22%20width%3D%22722%22%20height%3D%22531%22%20role%3D%22button%22%20title%3D%22txnelson_0-1658383099652.png%22%20alt%3D%22txnelson_0-1658383099652.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524304%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524304%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%B4%EC%9A%94!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222022-07-21_13-23-53.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-21_13-23-53.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-21_13-23-53.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-21_13-23-53.png%22%20style%3D%22width%3A%20398px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44170i30F00E5784D55D55%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222022-07-21_13-23-53.png%22%20alt%3D%222022-07-21_13-23-53.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524291%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524291%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%95%84%EB%A7%88%EB%8F%84%3CA%20href%3D%22https%3A%2F%2Fhelp.jmp.com%2Fhelp%3Fkeyword%3DJSL%2520Blob%2520Peek%26amp%3Blang%3Den%26amp%3Bos%3Dwin%26amp%3Bsource%3Dapplication%26amp%3Bversion%3D16.2.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20BLOB%20Peek(%EB%B8%94%EB%A1%AD%2C%20%EC%98%A4%ED%94%84%EC%85%8B%2C%20%EA%B8%B8%EC%9D%B4)%3C%2FA%3E%20%EC%9E%91%EB%8F%99%20%ED%95%A0%20%EA%B2%83%EC%9D%B4%EB%8B%A4%3F%20%EB%98%90%ED%95%9C%20%EC%9D%B4%EA%B2%83%EC%9D%80%20%EC%A2%8B%EC%9D%80%20%EC%8B%9C%EA%B3%84%20%EC%9D%BC%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscovery-Summit-Europe-2022%2FImporting-Binary-Data-with-JSL-2022-EU-45MP-946%2Fm-p%2F446124%23U446124%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-tkb-thread%20lia-fa-icon%20lia-fa-tkb%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%20JSL%EB%A1%9C%20%EC%9D%B4%EC%A7%84%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B8%B0(2022-EU-45MP-946)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524269%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%B0%94%EC%9D%B4%EB%84%88%EB%A6%AC%20%ED%8C%8C%EC%9D%BC%EC%9D%98%20%EC%9D%BC%EB%B6%80%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EA%B3%A0%20%EA%B0%9C%EB%B3%84%EC%A0%81%EC%9C%BC%EB%A1%9C%20%ED%8F%89%EA%B0%80%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524269%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CUL%3E%3CLI%3E%3CP%20class%3D%22%22%3E%EC%9D%B4%EA%B2%83%EC%9D%80%20%EC%84%B1%EA%B3%B5%EC%9D%84%20%EB%92%A4%EC%A7%91%EC%A7%80%20%EC%95%8A%EC%9D%84%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ebb%20%3D%20Load%20Text%20File(%20%22I%3A%5CE%5C00820070306.zst%22%2C%20blob()%20)%3B%0Aymd%20%3D%20Blob%20To%20Matrix(%20bb%2C%20%22uint%22%2C%204%2C%20%22little%22%2C%208%20)%3B%0A%0Aa%3DMunger(char(bb)%2Ccontains(char(bb)%2C%22(%22)%2B4%2C12)%3B%0Ab%3DChar%20To%20blob(a%2C%20%22utf-8%22%20)%3B%3B%0Amat%3Dblobtomatrix(b%2C%20%22uint%22%2C%204%2C%20%22little%22%2C%208%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
lala
Level IX

How do extract parts of a binary file and evaluate them separately?

Hello!

 

For example this file with this script can get the first data is a date.

2022-07-21_12-05-43.png
How do I use a script to extract this "A2 3F 32 01"
and use a script to calculate its corresponding decimal value= 20070306

 

Thanks!

 

8 REPLIES 8
lala
Level IX

Re: How do extract parts of a binary file and evaluate them separately?

  • This will not reverse success

bb = Load Text File( "I:\E\00820070306.zst", blob() );
ymd = Blob To Matrix( bb, "uint", 4, "little", 8 );

a=Munger(char(bb),contains(char(bb),"(")+4,12);
b=Char To blob(a, "utf-8" );;
mat=blobtomatrix(b, "uint", 4, "little", 8 );
jthi
Super User

Re: How do extract parts of a binary file and evaluate them separately?

Maybe BLOB Peek(blob, offset, length) would work? Also this might be a good watch  

-Jarmo
lala
Level IX

Re: How do extract parts of a binary file and evaluate them separately?

Thanks!

 

2022-07-21_13-23-53.png

txnelson
Super User

Re: How do extract parts of a binary file and evaluate them separately?

Your code

bb = Load Text File( "I:\E\00820070306.zst", blob() );
ymd = Blob To Matrix( bb, "uint", 4, "little", 8 );

is creating a 2 dimensional matrix you are calling "ymd" with the values converted to decimal values.  All you have to do, is to create a new data table, then create a new column and set the values in the new column to the first column in the matrix ymd.

Names Default To Here( 1 );

bb = Load Text File( "I:\E\00820070306.zst", blob() );
ymd = Blob To Matrix( bb, "uint", 4, "little", 8 );

dt = New Table( "zst" );
dt << New Column( "col 1" );
	Column( dt, 1 ) << set values( ymd[0, 1] );

Then just repeat it for the remaining 7 columns in the matrix

txnelson_0-1658383099652.png

 

Jim
lala
Level IX

Re: How do extract parts of a binary file and evaluate them separately?

Thank Jim!

Yes, I got this code from Craige.

This code is useful when it knows the binary data structure.

 

But this new file I don't know its data structure.I'm on a quest.

I'm wrapping this file at 00 intervals.I get the data for this.

Except for the first line which I know contains the date.

But the data starting in the second line is integer data, floating point data.But which field is a floating point, or an integer.I don't know.

2022-07-21_14-28-39.png

 

I can only restore the comparison field by field.

 

I still haven't figured it out yet.

 

txnelson
Super User

Re: How do extract parts of a binary file and evaluate them separately?

Best of luck

Jim
lala
Level IX

Re: How do extract parts of a binary file and evaluate them separately?

 

 

How can take something in hexadecimal form and compute it as a floating point?

~D9~40~D9~CE

The following code ran incorrectly

b = Char To Blob( "~D9~40~D9~CE", "ascii~hex" );
f = Blob To Matrix( b, "float", 4, "little", 4 );

Thanks!

lala
Level IX

Re: How do extract parts of a binary file and evaluate them separately?

  • OK

  • I just wrote the wrong code.

Thanks!

Recommended Articles