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

比如:


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

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值