Hello
I would like to know if it would be possible getting link information and a title to create a new link based on those 2 information
Is your question:
If I have a URL link in a column in a data table, and a title in another column in a data table, can I put that information together to come up with a new URL link in a third column?
If that is the question, the answer is yes, but I am not sure that is what you are asking. Can you please provide more specifics on what you are asking?
more specific
I have a table with
column 1 --> link (for example: https://community.jmp.com/)
column 2 --> name (for example JMP)
I would like to create column 3 as
column 3 --> JMP (similar to HYPERLINK function in excel)
reason is sometimes http are very long and not usable for viewing.
If not possible I can go thru excel no issue but would prefer to have all in JMP
This will do it:
// Assumes that you have a column called Header 3 with a description of what to get
// and another column called Header 1 with the actual URL
dt << new column("Select Logic", character,
formula(
dst = current data table(); // Need a local variable because this is a formula
If (Selected(),
sel_cols = dst << get selected columns;
sel_rows = dst << get selected rows;
if (islist(sel_cols),
// then
if (nitems(sel_cols) == 1 & nrows(sel_rows) == 1 &
uppercase(char(sel_cols[1])) == "Header 3",
my_url = column(dst, "Header 1")[sel_rows[1]];
web(my_url); // Does the actual work
); // end 1 col, 1 row, AER col
); // end islist
); // end if selected
"x"; // Need a dummy value for the column
); // end forumula
); // end new column
column(dt, "Select Logic") << hide;
ok got it. thank you very much
I did not know this web function but seems pretty cool.
Ok PMorz,
it doesnt really work.
I can actually create a logic column filled with "x"...
any hint?
