How do I include the dialog box ´Recode column names' in jsl script or a function that does something similar.

[#1]

Hi Community

I'm building a script in JMP 15 that imports data and performs a rough clean-up. In the process I need to convert a string of identifiers in a single columns (e.g. string; Trial_Replicate_DrugConcentration_Patient) to multiple columns using the text to columns() function and separation based on "_". This provides me with the desired columns, although without column header. Ideally I wan't the script to open up the 'Recode column names' dialog box so the user can set the names as needed. I would prefer a dialog box option if possible, to make the script easy to handle for inexperienced JMP users and making it usable for other strings as well. But I have not been able to find a way to open the dialog box through scripting - ala. Open()

I'm open to other suggestions

Thanks in advance!

Jakob

[#2 · Accepted solution]

You could examine the first row in the original column with the Words() function and obtain the number of columns to be named. You could then present a simple dialog with a string column edit box for the user to input their choice of names. You could optionally provide the values in that first row as a guide to the meaning of the columns.

[#3]

Thanks for the quick reply. It is a really good suggestion which makes automation more feasible. I'll try and adopt this approach over time as my newbie JSL skills develop

[#4 · Accepted solution]

You can access the Recode Column Names through the Main Menu() function.   

main menu("recode column names")

[#5]

Really simple solution. I will settle for this solution until my JSL skills develop further