521590_zh-CN

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 文件。