比如:
256.74,543.49,487.72,774.47,286.75,232.78,517.73));
247.74,528.49,472.72,753.47,280.75,226.96,505.73));
238.74,513.49,457.72,732.47,274.75,221.14,493.73));
229.74,498.49,442.72,711.47,268.75,215.33,481.73));
220.74,483.49,427.72,690.47,262.75,209.51,469.73));
211.74,468.49,412.72,669.47,256.75,203.69,457.73));
202.74,453.49,397.72,648.47,250.75,197.87,445.73));
193.74,438.49,382.72,627.47,244.75,192.05,433.73));
184.74,423.49,367.72,606.47,238.75,186.23,421.73));
175.74,408.49,352.72,585.47,232.75,180.41,409.73));
166.74,393.49,337.72,564.47,226.75,174.59,397.73));
157.74,378.49,322.72,543.47,220.75,168.77,385.73));
148.74,363.49,307.72,522.47,214.75,162.95,373.73));
139.74,348.49,292.72,501.47,208.75,157.13,361.73));
130.74,333.49,277.72,480.47,202.75,151.31,349.73));
121.74,318.49,262.72,459.47,196.75,145.49,337.73));
112.74,303.49,247.72,438.47,190.75,139.67,325.73));
103.74,288.49,232.72,417.47,184.75,133.85,313.73));
首先进行尾处理,去掉));
可以用UE列选择del,或者是TXT替换为空。
然后另存为后缀为csv的文件。打开方式为excle。如下:
这样的话就可以进行粘贴到其他文档里用了,比如doc。
表格==》逗号,顿号分隔文件
把整个表格复制,粘贴到UE中,会得到以Tab制表符分隔的文件。
48 $0.00$0.00 $0.00$0.00 $0.00$0.00 $0.00$0.01 $58.75$65.93 $11.64$12.16 $61.73$78.09
49 $0.00$0.00 $0.00$0.00 $0.00$0.00 $0.00$0.00 $52.75$59.93 $5.82$6.16 $49.73$66.09
50 $0.00$0.00 $0.00$0.00 $0.00$0.00 $0.00$0.00 $46.75$53.93 $0.00$0.16 $37.73$54.09
下来我们只需要把^t convert to 逗号,顿号 ,就可以了。
48,$0.00$0.00,$0.00$0.00,$0.00$0.00,$0.00$0.01,$58.75$65.93,$11.64$12.16,$61.73$78.09
49,$0.00$0.00,$0.00$0.00,$0.00$0.00,$0.00$0.00,$52.75$59.93,$5.82$6.16,$49.73$66.09
50,$0.00$0.00,$0.00$0.00,$0.00$0.00,$0.00$0.00,$46.75$53.93,$0.00$0.16,$37.73$54.09