回复: 如何將粘貼板的內容做成表格?
到

回复: 如何將粘貼板的內容做成表格?只需使用 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 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