I use a custom JMP interface to pull data from a database with the Open Database command. It is a common problem with query tools that you have a list of something in a data table or spreadsheet (part id's, for example) but are required to convert it into a comma separated list (along with the addition of single quotes) to work with an SQL statement.
I could not find a standard JMP box that would do what I wanted, and I wound up using the Script Box. The intent of that box is, of course, to run scripts, but it automatically creates a comma separated list with the << Get Lines message. The function is shown below, and the attached script shows it in action. There are probably other uses for converting a pasted list like this.
fn_scriptBox = Function( {_vv}, //formats the script box output for SQL
_yy = _vv << Get Lines;
_zz = "'";
For( i = 1, i <= N Items( _yy ), i++,
_zz ||= _yy || "','"
);
_zz = Left( _zz, Length( _zz ) - 2 );
);