现在的位置: 首页 > 综合 > 正文

逗号分隔的文件《==》转换成表格

2014年01月01日 ⁄ 综合 ⁄ 共 2929字 ⁄ 字号 评论关闭

比如:

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。如下:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 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
94.74 273.49 217.72 396.47 178.75 128.03 301.73
85.74 258.49 202.72 375.47 172.75 122.21 289.73
76.74 243.49 187.72 354.47 166.75 116.39 277.73
67.74 228.49 172.72 333.47 160.75 110.57 265.73
58.74 213.49 157.72 312.47 154.75 104.75 253.73
49.74 198.49 142.72 291.47 148.75 98.93 241.73
40.74 183.49 127.72 270.47 142.75 93.11 229.73
31.74 168.49 112.72 249.47 136.75 87.29 217.73
22.74 153.49 97.72 228.47 130.75 81.47 205.73
13.74 138.49 82.72 207.47 124.75 75.65 193.73

这样的话就可以进行粘贴到其他文档里用了,比如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

 

 

抱歉!评论已关闭.