521590_zh-TW

liliconcom

如何用這樣的字符串製作表格？

謝謝！

data<=>39.85,-0.015,0.002,1.017,1.70,3.90,-1.80,-3.80,-0.28,-12257.23,15:00,218879.08|39.70,-0.000,-0.000,0.935,3.60,3.50,-2.20,-4.90,-0.65,-357.77,09:30,5039.02|39.89,-0.001,-0.000,0.907,2.80,6.60,-10.90,1.50,-0.18,-882.37,09:32,9386.96|39.85,-0.001,0.000,1.020,0.20,4.20,-7.90,3.50,-0.28,-505.97,09:33,11499.35|

至

腳本回复：如何用這樣的字符串製作表格？

off1 = Contains( txt, "data<=>" );<BR />If( off1,<BR />txt = Substr( txt, off1 + 1, Length( txt ) )<BR />);<BR />off2 = Contains( txt, "|", -1 );<BR />If( off2,<BR />txt = Substr( txt, 1, off2  )<BR />);<BR />t1=Substitute(txt,":","",","," ","|",",");

回复：如何用這樣的字符串製作表格？

使用 Substitute Into 刪除 data<=> 然後使用 Words 兩次。 首先通過拆分“|”創建列表（行？），然後在“，”上獲取單元格的值。 然後根據需要更改格式並向數據表添加值，例如通過使用數據表下標和添加行。

Names Default To Here(1);

txt = "data<=>39.85,-0.015,0.002,1.017,1.70,3.90,-1.80,-3.80,-0.28,-12257.23,15:00,218879.08|39.70,-0.000,-0.000,0.935,3.60,3.50,-2.20,-4.90,-0.65,-357.77,09:30,5039.02|39.89,-0.001,-0.000,0.907,2.80,6.60,-10.90,1.50,-0.18,-882.37,09:32,9386.96|39.85,-0.001,0.000,1.020,0.20,4.20,-7.90,3.50,-0.28,-505.97,09:33,11499.35|";

Substitute Into(str, "data<=>", ""); // Remove "data<=>""
rows = Words(str, "|");
// example line
first_line = Words(rows[1], ",");

回复：如何用這樣的字符串製作表格？

回复：如何用這樣的字符串製作表格？

另一種方法。 如果您不知道列名，可以省略 columns(...) 部分。

txt = "data<=>39.85,-0.015,0.002,1.017,1.70,3.90,-1.80,-3.80,-0.28,-12257.23,15:00,218879.08|39.70,-0.000,-0.000,0.935,3.60,3.50,-2.20,-4.90,-0.65,-357.77,09:30,5039.02|39.89,-0.001,-0.000,0.907,2.80,6.60,-10.90,1.50,-0.18,-882.37,09:32,9386.96|39.85,-0.001,0.000,1.020,0.20,4.20,-7.90,3.50,-0.28,-505.97,09:33,11499.35|";

Open(
    Char To Blob( Munger( txt, 1, "data<=>", "" ) ),
    columns(
        New Column( "a" ),
        New Column( "b" ),
        New Column( "c" ),
        New Column( "d" ),
        New Column( "e" ),
        New Column( "f" ),
        New Column( "g" ),
        New Column( "h" ),
        New Column( "i" ),
        New Column( "j" ),
        New Column( "time", Informat( "h:m" ), Format( "h:m" ) ),
        New Column( "z" )
    ),
    Import Settings( End Of Line( Other( "|" ) ), Labels( 0 ), Data Starts( 1 ) )
);

 

這是我第一次使用 munger() 並且感覺很好。 看起來它的失敗行為（如果 data<=> 文本更改）將是合理的......保持文本不變並將其添加到第一個值。

 

Opening a blob of CSV-like data using | for line end characters.Opening a blob of CSV-like data using | for line end characters.使用 | 打開一個類似 CSV 的數據用於行尾字符。

 

open() 函數接受 blob 而不是文件名； import settings() 告訴它在 blob 中期待 .txt 或 .csv 文件。