笔记本TXT里的一种数据格式怎样批量转换成另外一种数据格式？

newer

jiaoquangb 发表于 2018-1-22 20:56

你去试下 http://bbs.xdcad.net/forum.php?m ... 72&fromuid=5280 ，你第一次上传的数据，看看对不对，我照那个写的，如果不对，

你把数据文件截图，不对的地方标记，应该是什么样的也写出来，对照，截图贴上来。

jiaoquangb

newer 发表于 2018-1-22 21:47

这是转换前的原始数据


下面是正确的转换后数据


下面是老师您的程序转换后的结果

比如：你转换后的第2行应该放在第3行；你转换后的第3行应该放在第2行，而且顺序要倒过来，并且都是正数，不是负数

hao3ren

各种软件数据格式太多了

jiaoquangb

hao3ren 发表于 2018-1-22 22:45

所以要编写插件呀，您会编写LSP程序吗？

jiaoquangb

adian2000 发表于 2018-1-22 12:39

帅哥，你在吗？
你在表格里写“原始文本最多3000行......总测点数小于333个”，这个怎么理解呀？每行不是代表一个测点吗？3000行应该有近3000个测点吧，是总测点数小于333个还是总测点数小于3330个呀？
还有“如果不够，请自行对表格进行处理”，怎样处理呀？

adian2000

jiaoquangb 发表于 2018-1-23 20:15

中桩总数小于333

adian2000

再次针对你的要求进行了修改。
我的excel是2007版本的，在2003版本下也能用。和xp应该没有什么关系。
目前你的三个文件都能转换。
不过你的转换前的文件中，有缺中桩高程的，在转换后的内容中有该错误提示。

jiaoquangb

adian2000 发表于 2018-1-24 16:07

帅哥，你最后上传的表格还是不支持EXCEL2003，打开表格，转换后的表格里不显示数值。下面是转换后的EXCEL2003显示出来的：

adian2000

jiaoquangb 发表于 2018-1-24 18:12

装一个2007版吧，我电脑里面没有2003了，你在别人那里试一试吧。这个excel表中没有用到2007版的特性，应该在2003版能用的。

jiaoquangb

adian2000 发表于 2018-1-25 09:29

帅哥，谢谢您的回复

f4800

LISP  感谢分享。。。。。。。。。。

f4800

newer 发表于 2018-1-22 18:42
LISP

这是标准的CASS横断面数据，里面是相对中心的距离和高程。
现在怎么快速的把桩号和0.000 处的高程单独提取出来保存。。
多谢了。。。。

希望得到的成果文件   *.txt 格式
420.000,39.410
440.000,39.350
460.000,37.080
480.000,36.980
500.000,37.020
520.000,37.000


CASS 的  *.hdm 原始数据
BEGIN,420.000:1
-70.000,35.910
-30.643,36.250
-20.122,39.830
-14.949,39.550
-14.949,39.550
-14.598,39.340
0.000,39.410
2.499,39.400
22.346,39.560
25.753,39.560
29.329,39.400
45.060,37.980
57.273,38.030
70.000,37.770
BEGIN,440.000:2
-70.000,36.150
-52.480,36.260
-40.661,36.850
-22.372,39.420
-19.556,39.410
-19.354,39.310
0.000,39.350
1.991,39.350
2.153,39.370
5.641,39.400
10.656,37.719
16.230,37.442
26.830,37.320
37.278,37.828
49.203,37.815
60.480,37.727
70.000,37.660
BEGIN,460.000:3
-70.000,37.020
-42.832,39.240
-42.737,39.320
-39.367,39.350
-39.145,39.240
-27.645,39.320
-21.145,39.304
-14.609,39.390
0.000,37.080
12.767,37.071
24.631,36.801
34.689,37.162
47.559,37.399
58.639,37.430
70.000,37.390
BEGIN,480.000:4
-70.000,38.980
-62.715,39.280
-59.427,39.300
-59.209,39.240
-38.171,39.190
-34.590,39.290
-2.804,36.684
0.000,36.980
20.057,36.777
30.058,36.558
42.146,36.485
55.198,36.810
66.610,37.481
70.000,37.200
BEGIN,500.000:5
-70.000,39.300
-58.068,39.160
-54.735,39.340
-48.378,37.460
-38.588,37.210
-20.904,37.080
0.000,37.020
15.558,36.891
24.548,36.971
33.704,37.431
43.978,37.176
51.674,37.163
58.099,36.936
70.000,37.010
BEGIN,520.000:6
-70.000,39.183
-68.420,39.102
-65.922,39.031
-63.190,37.333
-57.634,37.459
-41.514,37.408
-26.116,37.198
-15.375,37.143
0.000,37.000
9.020,37.286
15.191,37.297
17.808,37.033
21.720,36.953
29.652,37.482
40.277,37.144
49.924,36.901
59.004,37.078
70.000,37.132
BEGIN,540.000:7
-70.000,38.664
-66.500,37.737
-40.702,37.849
-16.781,37.220
0.000,37.380
4.526,37.075
16.314,37.131
20.098,37.083
31.740,37.195
43.438,37.164
52.478,36.795
62.526,37.187
70.000,37.168
BEGIN,560.000:8
-70.000,38.140
-49.594,38.167
-25.229,37.590
-5.879,37.362
0.000,37.280
11.266,37.254
13.701,37.191
16.380,37.136
19.790,37.382
29.595,37.547
42.027,37.209
51.331,37.170
61.203,37.035
70.000,37.060

具体信息：
cass    *.hdm文件介绍  ，其余数据无用
BEGIN,420.000:1                       420.000是桩号，
-70.000,35.910
-30.643,36.250
-20.122,39.830
-14.949,39.550
-14.949,39.550
-14.598,39.340
0.000,39.410                             39.410 是中心处高程
2.499,39.400
22.346,39.560
25.753,39.560
29.329,39.400
45.060,37.980
57.273,38.030
70.000,37.770

13174545660

keyiyonglema