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

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

JakobHerschend — Sun, 17 May 2020 08:08:04 GMT

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

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

Mark_Bailey — Sun, 17 May 2020 11:57:47 GMT

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.

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

txnelson — Sun, 17 May 2020 13:44:48 GMT

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

main menu("recode column names")

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

JakobHerschend — Mon, 18 May 2020 13:30:03 GMT

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 =)

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

JakobHerschend — Mon, 18 May 2020 13:31:15 GMT

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