How to make the content of the paste board into a table?

[#1]

The pasted board contains previous content, blank content, and tabs at the beginning of each line, and forms a table

Thanks!

 


	1	2023-09-09 00:00	A	C
	2	2023-09-09 00:00	B	D

[#2]

• There may be Spaces

to

[#3]

You might get quite far just by using Get Clipboard using open with blob

Names Default To Here(1);

str = Get Clipboard();
Open(Char to Blob(str), "text");

then perform cleanup in JMP table

[#4]

• Can I make a table with multiple columns directly through regular substitution?

Thanks!

[#5]

You can paste to a script window, clean up, and import. (You don't have to replace the tabs with commas and might not want to if the data contains commas.)

[#6]

Can this be done with JSL?I am still using JMP14 and cannot record.

t1=Regex(txt,"\!n\!n","\!n",globalreplace);
//？？

Thank Craige!

[#7]

Sure, either save it to a file with a .CSV extension, or convert to a blob and open from the blob (and tell open it is a "text" file.)

Note the regex pattern uses \n for a newline and the regex replacement uses JMP's \!n.

change multiple consecutive newlines to a single newline

[#8]

• Cannot be implemented using copied data

[#9]

on line 3, try changing txt to t1

The original text is likely to have CRLF pairs, but line 2's effect is lost by line 3 overwrite.

 you can also use the Hex(t1) function to see LF==x0A and CR==x0D