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%3ECan%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773936%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EI%20have%20a%20data%20table%20with%20a%20couple%20hundred%20columns.%20I%20would%20like%20to%20be%20able%20to%20search%20through%20all%20the%20column%20formulas%20to%20see%20if%20a%20particular%20column%20is%20used%20in%20any%20of%20the%20column%20formulas.%20Is%20this%20possible%3F%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%3EData%20Blending%20and%20Cleanup%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%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773949%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EYes......%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%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%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773951%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EIf%20you%20have%20access%20to%20JMP%20Pro%20you%20could%20do%20this%20with%20Formula%20Depot.%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%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20select%20the%20formula%20columns%2C%20select%20copy%20columns%2C%20open%20new%20script%20(ctrl%20%2B%20t)%20and%20paste%20there.%20Then%20search%20in%20script%20editor.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20also%20try%20removing%20that%20column%20and%20if%20it%20is%20being%20used%2C%20JMP%20will%20display%20warning%20like%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%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEdit%3A%3C%2FP%3E%0A%3CP%3EThere%20might%20be%20also%20some%20way%20in%20JMP18%20utilizing%20Columns%20Manager%20but%20I%20could%20figure%20one%20out.%20Data%20Dictionary%20almost%20can%20do%20it%20but%20it%20stores%20the%20formulas%20as%20images%20so%20they%20cannot%20be%20searched%20easily%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%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20of%20course%20there%20is%20plenty%20of%20pure%20scripting%20options%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773954%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773954%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJim%2C%3C%2FP%3E%3CP%3EThanks%20for%20this.%20Since%20I%20am%20really%20poor%20at%20scripting%20at%20this%20point%2C%20could%20you%20show%20me%20how%20I%20can%20have%20your%20algorithm%20loop%20through%20all%20the%20columns%20in%20a%20data%20table%20and%20output%20a%20list%20of%20columns%20that%20contain%20the%20target%20value%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJarmo%2C%3C%2FP%3E%3CP%3EUnfortunately%2C%20I%20don't%20have%20JMP%20Pro.%20For%20some%20reason%2C%20the%20error%20message%20I%20get%20when%20I%20try%20to%20delete%20the%20column%20does%20not%20list%20the%20column%20containing%20the%20formula.%20I%20don't%20know%20why.%20I%20also%20thought%20that%20the%20data%20dictionary%20might%20be%20able%20to%20help%20but%20I%20couldn't%20see%20how%20once%20I%20looked%20at%20it.%20Thanks%20for%20the%20assistance%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773958%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EI%20also%20shared%20one%20more%20option%20which%20isn't%20dependent%20on%20JMP%20Pro%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EYou%20can%20select%20the%20formula%20columns%2C%20select%20copy%20columns%2C%20open%20new%20script%20(ctrl%20%2B%20t)%20and%20paste%20there.%20Then%20search%20in%20script%20editor.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%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%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773979%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773979%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EOhhhh...%20That's%20cool.%20I%20didn't%20know%20you%20could%20paste%20a%20column%20into%20the%20script%20editor.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20that%20will%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774012%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ESimilar%20to%26nbsp%3B%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's%20suggestion%20to%20copy%20the%20script%20of%20each%20column%2C%20you%20can%20copy%20the%20script%20of%20the%26nbsp%3B%3CEM%3Eentire%20table%3C%2FEM%3E%20without%20the%20data%20using%20the%20Red%20Triangle%20(at%20the%20top%20left%20of%20the%20table)%20%26gt%3B%20Copy%20Table%20Script%20(no%20data).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%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%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20script%20will%20contain%20the%20jsl%20to%20recreate%20your%20table%2C%20which%20will%20include%20all%20your%20column%20formulas.%20Paste%20that%20script%20into%20a%20script%20window%2C%20and%20search%20from%20there.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps!%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%40julian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774025%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%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%20maybe%20this%20type%20of%20searches%20could%20be%20implemented%20to%20Column%20Manager%20in%20some%20capability%3F%20So%20we%20could%20also%20search%20for%20the%20values%20within%20Column%20Properties%20instead%20of%20just%20filtering%20down%20to%20those%20which%20have%20specific%20properties.%20At%20least%20Formula%2C%20Notes%20and%20Short%2FLong%20column%20names%20are%20few%20column%20properties%20which%20could%20possibly%20benefit%20if%20we%20could%20search%20from.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774037%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EI%20like%20it%E2%80%94Columns%20Manager%20feels%20like%20a%20natural%20place%20for%20that.%20I%20was%20also%20thinking%20of%20how%20it%20might%20work%20within%20the%20ordinary%20Find%20dialog%20if%20there%20were%20another%20checkbox%20to%20offer%20%E2%80%9CFind%20in%20Column%20Properties.%E2%80%9D%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776949%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EI%20started%20with%26nbsp%3B%26nbsp%3B%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%26nbsp%3B's%20idea%20to%20use%20the%20table%20script%20and%20added%20some%20functions%20to%3C%2FP%3E%3CP%3E-%20search%20for%20columns%20in%20the%20formulas%20and%3C%2FP%3E%3CP%3E-%20to%20display%20the%20search%20results%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%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%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777626%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Ebesides%20the%20approach%20to%20highlight%20column%20used%20in%20formulas%20via%20the%20column%20background%20color%2C%3CBR%20%2F%3Eone%20might%20think%20of%20adding%20a%26nbsp%3B%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%3EIndicator%20Symbol%20for%20Columns%20used%20in%20Formulas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777963%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Can%20you%20search%20column%20formulas%3F%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%26nbsp%3Bthis%20is%20brilliant.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

Can you search column formulas?

scott1588
Level IV

I have a data table with a couple hundred columns. I would like to be able to search through all the column formulas to see if a particular column is used in any of the column formulas. Is this possible?

11 REPLIES 11
hogi
Level XII


Re: Can you search column formulas?

besides the approach to highlight column used in formulas via the column background color,
one might think of adding a Indicator Symbol for Columns used in Formulas 

 

julian
Community Manager Community Manager


Re: Can you search column formulas?

@hogi this is brilliant.