topic 回复： How to make the content of the paste board into a table? in Discussions

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

lala — Thu, 10 Aug 2023 14:18:13 GMT

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

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

lala — Thu, 10 Aug 2023 01:14:47 GMT

There may be Spaces

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

jthi — Thu, 10 Aug 2023 05:07:26 GMT

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

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

lala — Thu, 10 Aug 2023 07:15:59 GMT

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

Thanks!

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

Craige_Hales — Thu, 10 Aug 2023 10:07:09 GMT

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

(view in My Videos)

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

lala — Thu, 10 Aug 2023 11:00:15 GMT

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

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

Thank Craige!

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

Craige_Hales — Thu, 10 Aug 2023 13:21:20 GMT

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

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

lala — Thu, 10 Aug 2023 14:46:07 GMT

Cannot be implemented using copied data

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

Craige_Hales — Thu, 10 Aug 2023 16:02:56 GMT

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