回复: 如何将粘贴板的内容做成表格?
到

回复: 如何将粘贴板的内容做成表格?只需使用 Get Clipboard using open with blob 就可以取得相当大的成果
Names Default To Here(1);
str = Get Clipboard();
Open(Char to Blob(str), "text");
然后在JMP表中执行清理
回复: 如何将粘贴板的内容做成表格?谢谢!
回复: 如何将粘贴板的内容做成表格?您可以粘贴到脚本窗口、清理并导入。 (您不必用逗号替换制表符,如果数据包含逗号,您可能也不想这样做。)
回复: 如何将粘贴板的内容做成表格?这可以用 JSL 来完成吗?我还在用JMP14,无法录音。
t1=Regex(txt,"\!n\!n","\!n",globalreplace);
//??
谢谢克雷格!
回复: 如何将粘贴板的内容做成表格?当然,可以将其保存到扩展名为 .CSV 的文件中,或者转换为 blob 并从 blob 打开(并告诉打开它是一个“文本”文件。)
请注意,正则表达式模式使用 \n 作为换行符,正则表达式替换使用 JMP 的 \!n。
change multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newlinechange multiple consecutive newlines to a single newline将多个连续换行符更改为单个换行符
如何将粘贴板的内容做成表格?粘贴的板子包含之前的内容、空白内容以及每行开头的制表符,并形成一个表格
谢谢!
<BR /><BR />
1 2023-09-09 00:00 A C
2 2023-09-09 00:00 B D
自动化和脚本编写回复: 如何将粘贴板的内容做成表格?
回复: 如何将粘贴板的内容做成表格?在第 3 行,尝试更改TXT到t1
原始文本可能有 CRLF 对,但第 2 行的效果因第 3 行覆盖而丢失。
您还可以使用 Hex(t1) 函数查看 LF==x0A 和 CR==x0D