cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E6%9C%89%E4%B8%80%E5%80%8B%E5%8C%85%E5%90%AB%E6%95%B8%E7%99%BE%E5%88%97%E7%9A%84%E8%B3%87%E6%96%99%E8%A1%A8%E3%80%82%E6%88%91%E5%B8%8C%E6%9C%9B%E8%83%BD%E5%A4%A0%E6%90%9C%E5%B0%8B%E6%89%80%E6%9C%89%E5%88%97%E5%85%AC%E5%BC%8F%EF%BC%8C%E4%BB%A5%E6%9F%A5%E7%9C%8B%E4%BB%BB%E4%BD%95%E5%88%97%E5%85%AC%E5%BC%8F%E4%B8%AD%E6%98%AF%E5%90%A6%E4%BD%BF%E7%94%A8%E4%BA%86%E7%89%B9%E5%AE%9A%E5%88%97%E3%80%82%E9%80%99%E5%8F%AF%E8%83%BD%E5%97%8E%EF%BC%9F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%E8%B3%87%E6%96%99%E6%B7%B7%E5%90%88%E8%88%87%E6%B8%85%E7%90%86%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773949%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773949%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%98%AF%E7%9A%84......%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0A%0Adt%20%3D%20%0A%2F%2F%20Open%20Data%20Table%3A%20Big%20Class.jmp%0A%2F%2F%20%E2%86%92%20Data%20Table(%20%22Big%20Class%22%20)%0AOpen(%20%22%2FC%3A%2FProgram%20Files%2FJMP%2FJMPPRO%2F19%2FSamples%2FData%2FBig%20Class.jmp%22%20)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20new%20column(%22Ratio%22%2C%20formula(%3Aheight%2F%3Aweight))%3B%0A%0AtheFormula%20%3D%20Char(dt%3ARatio%20%26lt%3B%26lt%3B%20get%20formula)%3B%0A%0AIf(%20contains(theFormula%2C%20%22height%22)%2C%20show(%22found%20it%22))%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773951%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773951%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%E5%A6%82%E6%9E%9C%E6%82%A8%E5%8F%AF%E4%BB%A5%E5%AD%98%E5%8F%96%20JMP%20Pro%EF%BC%8C%E5%89%87%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%20Formula%20Depot%20%E4%BE%86%E5%AE%8C%E6%88%90%E6%AD%A4%E6%93%8D%E4%BD%9C%E3%80%82%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1721326886768.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66308i4153AA45EBEA2641%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_1-1721326886768.png%22%20alt%3D%22jthi_1-1721326886768.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%82%A8%E5%8F%AF%E4%BB%A5%E9%81%B8%E6%93%87%E5%85%AC%E5%BC%8F%E5%88%97%EF%BC%8C%E9%81%B8%E6%93%87%E8%A4%87%E8%A3%BD%E5%88%97%EF%BC%8C%E9%96%8B%E5%95%9F%E6%96%B0%E8%85%B3%E6%9C%AC%EF%BC%88ctrl%20%2B%20t%EF%BC%89%E4%B8%A6%E8%B2%BC%E4%B8%8A%E5%88%B0%E9%82%A3%E8%A3%A1%E3%80%82%E7%84%B6%E5%BE%8C%E5%9C%A8%E8%85%B3%E6%9C%AC%E7%B7%A8%E8%BC%AF%E5%99%A8%E4%B8%AD%E6%90%9C%E5%B0%8B%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%82%A8%E4%B9%9F%E5%8F%AF%E4%BB%A5%E5%98%97%E8%A9%A6%E5%88%AA%E9%99%A4%E8%A9%B2%E5%88%97%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%AD%A3%E5%9C%A8%E4%BD%BF%E7%94%A8%E8%A9%B2%E5%88%97%EF%BC%8CJMP%20%E5%B0%87%E9%A1%AF%E7%A4%BA%E9%A1%9E%E4%BC%BC%E4%BB%A5%E4%B8%8B%E7%9A%84%E8%AD%A6%E5%91%8A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721326874531.png%22%20style%3D%22width%3A%20372px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66307i7EC950140C678ECF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1721326874531.png%22%20alt%3D%22jthi_0-1721326874531.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E7%B7%A8%E8%BC%AF%EF%BC%9A%3C%2FP%3E%0A%3CP%3EJMP18%20%E4%B8%AD%E5%8F%AF%E8%83%BD%E9%82%84%E6%9C%89%E6%9F%90%E7%A8%AE%E5%88%A9%E7%94%A8%E5%88%97%E7%AE%A1%E7%90%86%E5%99%A8%E7%9A%84%E6%96%B9%E6%B3%95%EF%BC%8C%E4%BD%86%E6%88%91%E5%8F%AF%E4%BB%A5%E6%89%BE%E5%88%B0%E4%B8%80%E7%A8%AE%E6%96%B9%E6%B3%95%E3%80%82%E8%B3%87%E6%96%99%E5%AD%97%E5%85%B8%E5%B9%BE%E4%B9%8E%E5%8F%AF%E4%BB%A5%E5%81%9A%E5%88%B0%EF%BC%8C%E4%BD%86%E5%AE%83%E5%B0%87%E5%85%AC%E5%BC%8F%E5%84%B2%E5%AD%98%E7%82%BA%E5%9C%96%E5%83%8F%EF%BC%8C%E5%9B%A0%E6%AD%A4%E7%84%A1%E6%B3%95%E8%BC%95%E9%AC%86%E6%90%9C%E5%B0%8B%E5%AE%83%E5%80%91%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721327241713.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66309i9AFB3C182B0F0BF4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1721327241713.png%22%20alt%3D%22jthi_0-1721327241713.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E7%95%B6%E7%84%B6%E9%82%84%E6%9C%89%E5%BE%88%E5%A4%9A%E7%B4%94%E8%85%B3%E6%9C%AC%E9%81%B8%E9%A0%85%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773954%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773954%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E5%90%89%E5%A7%86%EF%BC%8C%3C%2FP%3E%3CP%3E%E8%AC%9D%E8%AC%9D%E4%BD%A0%E3%80%82%E7%94%B1%E6%96%BC%E6%88%91%E7%9B%AE%E5%89%8D%E4%B8%8D%E6%93%85%E9%95%B7%E7%B7%A8%E5%AF%AB%E8%85%B3%E6%9C%AC%EF%BC%8C%E6%82%A8%E8%83%BD%E5%90%A6%E5%90%91%E6%88%91%E5%B1%95%E7%A4%BA%E5%A6%82%E4%BD%95%E8%AE%93%E6%82%A8%E7%9A%84%E6%BC%94%E7%AE%97%E6%B3%95%E5%BE%AA%E7%92%B0%E9%81%8D%E6%AD%B7%E8%B3%87%E6%96%99%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E5%88%97%E4%B8%A6%E8%BC%B8%E5%87%BA%E5%8C%85%E5%90%AB%E7%9B%AE%E6%A8%99%E5%80%BC%E7%9A%84%E5%88%97%E5%88%97%E8%A1%A8%EF%BC%9F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E9%9B%85%E7%88%BE%E8%8E%AB%2C%3C%2FP%3E%3CP%3E%E4%B8%8D%E5%B9%B8%E7%9A%84%E6%98%AF%EF%BC%8C%E6%88%91%E6%B2%92%E6%9C%89%20JMP%20Pro%E3%80%82%E7%94%B1%E6%96%BC%E6%9F%90%E7%A8%AE%E5%8E%9F%E5%9B%A0%EF%BC%8C%E7%95%B6%E6%88%91%E5%98%97%E8%A9%A6%E5%88%AA%E9%99%A4%E5%88%97%E6%99%82%E6%94%B6%E5%88%B0%E7%9A%84%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%E6%9C%AA%E5%88%97%E5%87%BA%E5%8C%85%E5%90%AB%E5%85%AC%E5%BC%8F%E7%9A%84%E5%88%97%E3%80%82%E6%88%91%E4%B8%8D%E7%9F%A5%E9%81%93%E7%82%BA%E4%BB%80%E9%BA%BC%E3%80%82%E6%88%91%E9%82%84%E8%AA%8D%E7%82%BA%E8%B3%87%E6%96%99%E5%AD%97%E5%85%B8%E5%8F%AF%E8%83%BD%E6%9C%83%E6%9C%89%E6%89%80%E5%B9%AB%E5%8A%A9%EF%BC%8C%E4%BD%86%E4%B8%80%E6%97%A6%E6%88%91%E6%9F%A5%E7%9C%8B%E5%AE%83%EF%BC%8C%E6%88%91%E5%B0%B1%E4%B8%8D%E7%9F%A5%E9%81%93%E5%A6%82%E4%BD%95%E5%B9%AB%E5%8A%A9%E3%80%82%E4%B8%8D%E9%81%8E%E9%82%84%E6%98%AF%E8%AC%9D%E8%AC%9D%E4%BD%A0%E7%9A%84%E5%B9%AB%E5%BF%99%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E9%82%84%E5%88%86%E4%BA%AB%E4%BA%86%E5%8F%A6%E4%B8%80%E5%80%8B%E4%B8%8D%E4%BE%9D%E8%B3%B4%20JMP%20Pro%20%E7%9A%84%E9%81%B8%E9%A0%85%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CEM%3E%E6%82%A8%E5%8F%AF%E4%BB%A5%E9%81%B8%E6%93%87%E5%85%AC%E5%BC%8F%E5%88%97%EF%BC%8C%E9%81%B8%E6%93%87%E8%A4%87%E8%A3%BD%E5%88%97%EF%BC%8C%E9%96%8B%E5%95%9F%E6%96%B0%E8%85%B3%E6%9C%AC%EF%BC%88ctrl%20%2B%20t%EF%BC%89%E4%B8%A6%E8%B2%BC%E4%B8%8A%E5%88%B0%E9%82%A3%E8%A3%A1%E3%80%82%E7%84%B6%E5%BE%8C%E5%9C%A8%E8%85%B3%E6%9C%AC%E7%B7%A8%E8%BC%AF%E5%99%A8%E4%B8%AD%E6%90%9C%E5%B0%8B%E3%80%82%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1721329913297.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66310i86ECDCACE3C6E4C3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1721329913297.png%22%20alt%3D%22jthi_0-1721329913297.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_2-1721329951299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66312iF64AC2E7EC7AD827%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_2-1721329951299.png%22%20alt%3D%22jthi_2-1721329951299.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773979%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773979%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E5%93%A6%E5%93%A6...%E9%82%A3%E5%A4%AA%E9%85%B7%E4%BA%86%E3%80%82%E6%88%91%E4%B8%8D%E7%9F%A5%E9%81%93%E6%82%A8%E5%8F%AF%E4%BB%A5%E5%B0%87%E5%88%97%E8%B2%BC%E5%88%B0%E8%85%B3%E6%9C%AC%E7%B7%A8%E8%BC%AF%E5%99%A8%E4%B8%AD%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E6%88%91%E8%AA%8D%E7%82%BA%E9%80%99%E6%9C%83%E8%B5%B7%E4%BD%9C%E7%94%A8%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E8%AC%9D%E8%AC%9D%EF%BC%81%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E8%88%87%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%40jthi%3C%2FA%3E%E5%BB%BA%E8%AD%B0%E8%A4%87%E8%A3%BD%E6%AF%8F%E5%88%97%E7%9A%84%E8%85%B3%E6%9C%AC%E9%A1%9E%E4%BC%BC%EF%BC%8C%E6%82%A8%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E7%B4%85%E8%89%B2%E4%B8%89%E8%A7%92%E5%BD%A2%EF%BC%88%E8%A1%A8%E5%B7%A6%E4%B8%8A%E8%A7%92%EF%BC%89%26gt%3B%20%E8%A4%87%E8%A3%BD%E8%A1%A8%E8%85%B3%E6%9C%AC%EF%BC%88%E7%84%A1%E8%B3%87%E6%96%99%EF%BC%89%E4%BE%86%E8%A4%87%E8%A3%BD%E6%B2%92%E6%9C%89%E8%B3%87%E6%96%99%E7%9A%84%3CEM%3E%E6%95%B4%E5%80%8B%E8%A1%A8%3C%2FEM%3E%E7%9A%84%E8%85%B3%E6%9C%AC%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22julian_0-1721339096365.png%22%20style%3D%22width%3A%20270px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66317iD300A27783CE719D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22julian_0-1721339096365.png%22%20alt%3D%22julian_0-1721339096365.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E8%A9%B2%E8%85%B3%E6%9C%AC%E5%B0%87%E5%8C%85%E5%90%AB%E7%94%A8%E6%96%BC%E9%87%8D%E6%96%B0%E5%BB%BA%E7%AB%8B%E8%A1%A8%E7%9A%84%20jsl%EF%BC%8C%E5%85%B6%E4%B8%AD%E5%B0%87%E5%8C%85%E6%8B%AC%E6%89%80%E6%9C%89%E5%88%97%E5%85%AC%E5%BC%8F%E3%80%82%E5%B0%87%E8%A9%B2%E8%85%B3%E6%9C%AC%E8%B2%BC%E5%88%B0%E8%85%B3%E6%9C%AC%E8%A6%96%E7%AA%97%E4%B8%AD%EF%BC%8C%E7%84%B6%E5%BE%8C%E5%BE%9E%E9%82%A3%E8%A3%A1%E9%80%B2%E8%A1%8C%E6%90%9C%E5%B0%8B%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E6%88%91%E5%B8%8C%E6%9C%9B%E9%80%99%E6%9C%89%E5%B9%AB%E5%8A%A9%EF%BC%81%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2026%22%20target%3D%22_blank%22%3E%40%E6%9C%B1%E5%88%A9%E5%AE%89%3C%2FA%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774025%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774025%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2026%22%20target%3D%22_blank%22%3E%40julian%3C%2FA%3E%E4%B9%9F%E8%A8%B1%E9%80%99%E7%A8%AE%E9%A1%9E%E5%9E%8B%E7%9A%84%E6%90%9C%E5%B0%8B%E5%8F%AF%E4%BB%A5%E5%9C%A8%E6%9F%90%E4%BA%9B%E5%8A%9F%E8%83%BD%E4%B8%AD%E5%AF%A6%E7%8F%BE%E5%88%B0%E5%88%97%E7%AE%A1%E7%90%86%E5%99%A8%EF%BC%9F%E5%9B%A0%E6%AD%A4%EF%BC%8C%E6%88%91%E5%80%91%E4%B9%9F%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E3%80%8C%E5%88%97%E5%B1%AC%E6%80%A7%E3%80%8D%E4%B8%AD%E7%9A%84%E5%80%BC%EF%BC%8C%E8%80%8C%E4%B8%8D%E5%83%85%E5%83%85%E6%98%AF%E9%81%8E%E6%BF%BE%E5%88%B0%E5%85%B7%E6%9C%89%E7%89%B9%E5%AE%9A%E5%B1%AC%E6%80%A7%E7%9A%84%E5%80%BC%E3%80%82%E8%87%B3%E5%B0%91%E5%85%AC%E5%BC%8F%E3%80%81%E8%A8%BB%E9%87%8B%E5%92%8C%E7%9F%AD%2F%E9%95%B7%E5%88%97%E5%90%8D%E7%A8%B1%E6%98%AF%E5%B0%91%E6%95%B8%E5%88%97%E5%B1%AC%E6%80%A7%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%88%91%E5%80%91%E5%8F%AF%E4%BB%A5%E5%BE%9E%E4%B8%AD%E9%80%B2%E8%A1%8C%E6%90%9C%E7%B4%A2%EF%BC%8C%E5%AE%83%E5%80%91%E5%8F%AF%E8%83%BD%E6%9C%83%E5%8F%97%E7%9B%8A%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E6%88%91%E5%96%9C%E6%AD%A1%E5%AE%83%E2%80%94%E2%80%94Columns%20Manager%20%E6%84%9F%E8%A6%BA%E6%98%AF%E4%B8%80%E5%80%8B%E5%BE%88%E8%87%AA%E7%84%B6%E7%9A%84%E5%9C%B0%E6%96%B9%E3%80%82%E6%88%91%E9%82%84%E5%9C%A8%E8%80%83%E6%85%AE%E5%A6%82%E6%9E%9C%E6%9C%89%E5%8F%A6%E4%B8%80%E5%80%8B%E8%A4%87%E9%81%B8%E6%A1%86%E6%8F%90%E4%BE%9B%E2%80%9C%E5%9C%A8%E5%88%97%E5%B1%AC%E6%80%A7%E4%B8%AD%E6%9F%A5%E6%89%BE%E2%80%9D%EF%BC%8C%E5%AE%83%E5%9C%A8%E6%99%AE%E9%80%9A%E7%9A%84%E2%80%9C%E6%9F%A5%E6%89%BE%E2%80%9D%E5%B0%8D%E8%A9%B1%E6%A1%86%E4%B8%AD%E5%B0%87%E5%A6%82%E4%BD%95%E5%B7%A5%E4%BD%9C%E3%80%82%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%E6%88%91%E5%BE%9E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2026%22%20target%3D%22_blank%22%3E%40julian%3C%2FA%3E%E7%9A%84%E6%83%B3%E6%B3%95%E9%96%8B%E5%A7%8B%E4%BD%BF%E7%94%A8%E8%A1%A8%E6%A0%BC%E8%85%B3%E6%9C%AC%E4%B8%A6%E6%B7%BB%E5%8A%A0%E4%BA%86%E4%B8%80%E4%BA%9B%E5%87%BD%E6%95%B8%3C%2FP%3E%3CP%3E-%20%E6%90%9C%E5%B0%8B%E5%85%AC%E5%BC%8F%E4%B8%AD%E7%9A%84%E5%88%97%E5%92%8C%3C%2FP%3E%3CP%3E-%20%E9%A1%AF%E7%A4%BA%E6%90%9C%E5%B0%8B%E7%B5%90%E6%9E%9C%EF%BC%9A%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2FOpen(%20%22%24SAMPLE_DATA%2FShip%20Damage.jmp%22%20)%3B%0A%2F%2F%20get%20all%20column%20formulas%20via%20the%20table%20script%20%0Adt%20%3D%20Current%20Data%20Table()%3B%0Adt%20%26lt%3B%26lt%3B%20copy%20table%20script(%20%22No%20Data%22%20)%3B%0Ascript%20%3D%20Parse(%20Get%20Clipboard()%20)%3B%0A%0A%2F%2Fconvert%20to%20List%20for%20easier%20indexing%0ASubstitute%20Into(%20script%2C%20Expr(%20New%20Table()%20)%2C%20Expr(%20%7B%7D%20)%20)%3B%0A%0A%2F%2F%20just%20keep%20the%20columns%0AallCols%20%3D%20Filter%20Each(%20%7Bcol%7D%2C%20script%2C%20Head(%20col%20)%20%3D%3D%20Expr(%20New%20Column()%20)%20)%3B%0A%0A%2F%2F%20convert%20column%20info%20into%20lists%0AColList%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20allCols%2C%20Substitute(%20Name%20Expr(%20col%20)%2C%20Expr(%20New%20Column()%20)%2C%20Expr(%20%7B%7D%20)%20)%20)%3B%0AallColNames%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20ColList%2C%20tmp%20%3D%20Arg(%20col%2C%201%20)%3B%20If%20(is%20string(tmp)%2C%20tmp%2C%20tmp%5B%22en%22%5D)%20)%3B%0A%0A%2F%2F%20keep%20columns%20with%20formulas%0AColsWithFormulas%20%3D%20Filter%20Each(%20%7Bcol%7D%2C%20ColList%2CTry(col%5B%22Formula%22%5D%3B%091%09%2C%090%09))%3B%0A%0AColNames%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20ColsWithFormulas%2C%20tmp%20%3D%20Arg(%20col%2C%201%20)%3B%20If%20(is%20string(tmp)%2C%20tmp%2C%20tmp%5B%22en%22%5D)%20)%3B%0AColFormulas%20%3D%20Transform%20Each(%20%7Bcol%7D%2C%20ColsWithFormulas%2C%20col%5B%22Formula%22%5D%20)%3B%0A%0A%2F%2F%20helper%20function%20to%20search%20for%20column%20names%20in%20formulas%0AContainsExpr%20%3D%20Function(%20%7Bexpression%2C%20pattern%7D%2C%0A%09tmp%20%3D%20Substitute(%20Name%20Expr(%20expression%20)%2C%20Name%20Expr(%20pattern%20)%2C%20Expr(%20.%20)%20)%3B%0A%09Not(%20Name%20Expr(%20tmp%20)%20%3D%3D%20Name%20Expr(%20expression%20)%20)%3B%0A)%3B%0A%20%0Asummary%20%3D%20New%20Table(%22Formuala%20Overview%22%2C%0A%09New%20Column(%20%22column%20Formula%22%2C%20Character%20)%2C%0A%09New%20Column(%20%22used%20cols%22%2C%20Character%20)%2C%20%09%0A)%3B%0Await(0)%3B%0A%0A%2F%2F%20fill%20the%20summary%20tale%20with%20all%20combinations%20of%20formulas%20and%20the%20used%20columns%0A%0ACurrent%20Data%20Table(%20dt%20)%3B%20%20%2F%2F%20make%20dt%20the%20current%20data%20table%2C%20otherwise%20%3CAS%20column%3D%22%22%3E%20won't%20work%20!%0AFor%20Each(%20%7BmyFormula%2C%20idx1%7D%2C%20ColFormulas%2C%0A%09For%20Each(%20%7Bcol%7D%2C%20allColNames%2C%0A%09%09formulaCol%20%3D%20ColNames%5Bidx1%5D%3B%0A%09%09dt%3AformulaCol%20%26lt%3B%26lt%3B%20Set%20Header%20Text%20Color(%20%22Red%22%20)%3B%0A%09%09If(%20ContainsExpr(%20Name%20Expr(%20myFormula%20)%2C%20Name%20Expr(%20As%20Column(%20col%20)%20)%20)%2C%0A%09%09%09Eval(%20Eval%20Expr(%20summary%20%26lt%3B%26lt%3B%20add%20row(%20%7B%22column%20Formula%22n%20%3DExpr(formulaCol%20)%2C%20%22used%20cols%22n%20%3D%20Expr(%20col%20)%7D%20)%20)%20)%3B%0A%09%09%09Column(col)%20%26lt%3B%26lt%3B%20Set%20Header%20Background%20Color(%20%7B102%2C%20255%2C%20140%7D%20)%3B%0A%09%09)%0A%09)%0A)%3B%0A%20%0A%2F%2F%20show%20a%20tabulate%20for%20easy%20look%20up%0Asummary%20%26lt%3B%26lt%3B%20Tabulate(%0A%09Show%20Control%20Panel(%200%20)%2C%0A%09Add%20Table(%20Row%20Table(%20Grouping%20Columns(%20%3Acolumn%20Formula%2C%20%3Aused%20cols%20)%20)%20)%2C%0A%09Local%20Data%20Filter(%20Mode(%20Show(%200%20)%20)%2C%20Add%20Filter(%20columns(%20%3Acolumn%20Formula%2C%20%3Aused%20cols%20)%20)%20)%0A)%3B%3C%2FAS%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777626%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777626%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E9%99%A4%E4%BA%86%E9%80%8F%E9%81%8E%E5%88%97%E8%83%8C%E6%99%AF%E9%A1%8F%E8%89%B2%E7%AA%81%E5%87%BA%E9%A1%AF%E7%A4%BA%E5%85%AC%E5%BC%8F%E4%B8%AD%E4%BD%BF%E7%94%A8%E7%9A%84%E5%88%97%E7%9A%84%E6%96%B9%E6%B3%95%E4%B9%8B%E5%A4%96%EF%BC%8C%3CBR%20%2F%3E%E4%BA%BA%E5%80%91%E5%8F%AF%E8%83%BD%E6%9C%83%E8%80%83%E6%85%AE%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FIndicator-Symbol-for-Columns-used-in-Formulas-batch-replace%2Fm-p%2F720399%23U720399%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%E7%82%BA%E5%85%AC%E5%BC%8F%E4%B8%AD%E4%BD%BF%E7%94%A8%E7%9A%84%E5%88%97%E6%B7%BB%E5%8A%A0%E6%8C%87%E7%A4%BA%E7%AC%A6%E8%99%9F%3C%2FA%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777963%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E6%82%A8%E5%8F%AF%E4%BB%A5%E6%90%9C%E5%B0%8B%E5%88%97%E5%85%AC%E5%BC%8F%E5%97%8E%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777963%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26800%22%20target%3D%22_blank%22%3E%40hogi%3C%2FA%3E%E9%80%99%E5%A4%AA%E6%A3%92%E4%BA%86%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

您可以搜尋列公式嗎?

scott1588
Level IV

我有一個包含數百列的資料表。我希望能夠搜尋所有列公式,以查看任何列公式中是否使用了特定列。這可能嗎?

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回English (US)。

11 REPLIES 11
hogi
Level XII

回覆:您可以搜尋列公式嗎?

除了透過列背景顏色突出顯示公式中使用的列的方法之外,
人們可能會考慮為公式中使用的列添加指示符號

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回English (US)。

julian
Community Manager Community Manager

回覆:您可以搜尋列公式嗎?

@hogi這太棒了。

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回English (US)。