Any suggestions on how to open\convert a BMP (bitmap image) file as\to a table? Ideally would like to have columns like X, Y, R, G, B with all the information, so that when plotted would resemble actual BMP. Might be some external converter first, then open a CSV file, might be a script that reads binary file and poarses into a tble, might be some built in function? ... View more

Hello all,    I'm trying to use Include File List() and I'm getting errors. It is not working as I would have expected. Here is an example. I have 3 files files named Include1.jsl, Include2.jsl, Include3.jsl that I'm trying to include into TestInclude.jsl that is listed below:   Clear Log(); //Names Default To Here( 1 ); Clear Symbols(); Clear Globals(); Include( "Include1.jsl" ); Include( "Include2.jsl" ); Include( "Include3.jsl" ); show(Include File List()); All four files are in the same folder.  Each of the three included files have their corresponding  show("IncludeScriptN"); where N is 1, 2 and 3 When I'm running the TestInclude,jsl, I'm expecting to see: "IncludeScript1"; "IncludeScript2"; "IncludeScript3"; Include File List() = {"C:\...\TestingLocaleScipts\TestInclude.jsl", "C:\...\TestingLocaleScipts\Include1.jsl", "C:\...\TestingLocaleScipts\Include2.jsl", "C:\...\TestingLocaleScipts\Include3.jsl"}; Instead I see this: "IncludeScript1"; "IncludeScript2"; "IncludeScript3"; Include File List() = {"C:\...\TestingLocaleScipts\TestInclude.jsl"} So, included files ARE indeed included, they DO indeed work, but function does not show them? What am I doing wrong?   Thanks,  M. ... View more

All,    I cannot find a way to do the following:   Let's say I have an App that is in the form of AddIn. For it to successfully run it needs some conditions met. When they are not I want to create a modal window with description what's needed to run the App and on hitting "OK" button close the App (not JMP though). How can I close a running App within this App using JSL (I'm going to put it as script to Butotn Box with "OK").   Thanks,  M. ... View more

All,    Simple task, but on a great scale. I have a table with two columns that have two different naming conventions for the same thing. Few hundreds of rows. Let's say something like that: NATO reporting name Common name Faceplate Mikoyan-Gurevich Ye-2A **bleep**ot Mikoyan-Gurevich MiG-15 Fang Lavochkin La-11 Fantail Lavochkin La-15 Fantan Nanchang Q-5/A-5 Fargo Mikoyan-Gurevich MiG-9 Farmer Shenyang J-6   and   Mikoyan-Gurevich MiG-19   [1] Feather Yakovlev Yak-15/Yak-17 Fencer Sukhoi Su-24 Fiddler Tupolev Tu-28/Tu-128 Fin Lavochkin La-7 Finback Shenyang J-8 Firebar Yakovlev Yak-28P Firebird Chengdu J-10 Fire Fang Chengdu J-20 Firkin Sukhoi Su-47 Fishbed Mikoyan-Gurevich MiG-21 Fishcan Chengdu J-7[2] Fishpot Sukhoi Su-9   and   Su-11   and so on. Now I need an easy way of creating a Match formula out of these columns. Any suggestion rather than parsing the table externally and adding pieces of formula around it? The reason I need a formula, and not a Virtual Join or something is that I have a column that have mixed names, some are Nato reporting name some are common names. Formula would work on Nato names, changing it to Common Names, leaving Common Names untouched.   Also, any other way of reducing two naming conventions in one column to one if I have a table of matched names from both conventions?   Thanks!   ... View more

How do I perform File Functions on multiple files using wildcards? Let's say after finished with files I'd like to sort them into corresponding folders like that:   Move Files("c:/temp/*.jmp", "c:/temp/processed_jmp/"); Move Files("c:/temp/*.csv", "c:/temp/processed_csv/"); Looks like this won't work with wildecards. I'd hate to go into getting list of all files, break it into separate lists for each extension, then making FOR loops to iterate through each file.... Is there a more elegant way of doing that?     ... View more

Hello everybody.    Let's say I have an array with strings that are values of rows that I need to pull from DB. Let's say the array is: searchStringArray = {'qwe', 'rty', 'asd',' fgh', 'zxc'} I can construct my WHERE statement in my query in a pretty simple way: "WHERE t1.column1 IN (' " || Concat Items(searchStringsArray, " ', ' ")|| " ' )" which when parsed would give me the following string: "WHERE t1.column1 IN('qwe', 'rty', 'asd', 'fgh', 'zxc')" But what if my searchStringArray has not full strings but partial strings?   I need to simplify my script. Currently I have a query that has multiple Contains statements, which in SQL looks like this: "WHERE (t1.column1 LIKE '%qwe%') OR (t1.column1 LIKE '%rty%') OR (t1.column1 LIKE '%asd%') OR (t1.column1 LIKE '%fgh%') OR (t1.column1 LIKE '%zxc%')" This is pretty cumbersome to construct from a string array. I was wondering if I can write an equivalent WHERE statement that looks something like this: "WHERE t1.column1 IN ('%qwe%', '%rty%', '%asd%', '%fgh%', '%zxc%')" or something like this: "WHERE t1.column1 MATCH('%qwe%' OR '%rty%' OR '%asd%' OR '%fgh%' OR '%zxc%')" or something similar that would be easier to construct using  Concat Items() . I tried two examples above, although they seem to be valid SQLite syntax, they do not work in JSL. Any suggestions?   Thanks,  M    ... View more

When I run my App I'm getting this error: Unresolved Column in access or evaluation of 'DataIndex:date' , As Column/*###*/() when running this line:   dt_POS << Select Columns( :"DataIndex:date", :Pos_X, :Pos_Y ); If I copy that line in a separate script window and run it immediately on the same table, it works just fine. Any ideas why?       ... View more