- 帖子
- 21
- 积分
- 21
- 技术
- 0
- 捐助
- 0
- 注册时间
- 2011-7-8
|
感谢Batcher 的提点,是这样的,我有一个文本name.txt,里面包含了很多文件的名称,如下:
1112200
1112300
1112320
1112340
1112350
1134050
1134100
1134110
每个对应的文件内的数据比如1112200.txt的内容如下
# Title: GRDC STATION DATA FILE
# --------------
# Format: DOS-ASCII
# Date format: YYYY-MM-DD; YYYY-MM; YYYY; MM
# Field delimiter: ;
#
# file generation data: 2011-07-07
#
# GRDC-No.: 1112300
# River: SENEGAL
# Station: GALOUGO
# Country: ML
# Latitude (dec. ?: 13.830000
# Longitude (de. ?: -11.130000
# Catchment area (km?: 127000.000
# Altitude (m.a.s.l): 69.00
# Next d/s station: 1112100
# Remarks:
#************************************************************
#
# Data Set Content: MEAN MONTHLY DISCHARGE
# --------------------
# Unit: m?s
# Time series: 1905 - 1990
# No. of years: 86
# Last update: 1992-06-26
#
# Table Header:
# YYYY-MM-DD - Date (DD=00)
# hh:mm - Time
# Original - original (provided) data
# Calculated - GRDC modified data
# Flag - modification flag
# -999 - missing data, no correction
# 300+n - n = number of missing values, when determined from mean daily discharge
# 99 - usage not recommended by the provider
# 100 - corrected data, no methode specified
#
# Data lines: 1032
# DATA
YYYY-MM-DD;hh:mm; Original; Calculated; Flag
1905-01-00;--:--; -999.000; -999.000; -999
1905-02-00;--:--; -999.000; -999.000; -999
1905-03-00;--:--; -999.000; -999.000; -999
1905-04-00;--:--; -999.000; -999.000; -999
1905-05-00;--:--; 14.000; -999.000; -999
1906-01-00;--:--; 155.000; -999.000; -999
我就是想通过name.txt依次获取文件名。然后对该文件提取其中的
1905-01-00;--:--; -999.000; -999.000; -999
1905-02-00;--:--; -999.000; -999.000; -999
1905-03-00;--:--; -999.000; -999.000; -999
1905-04-00;--:--; -999.000; -999.000; -999
1905-05-00;--:--; 14.000; -999.000; -999
1906-01-00;--:--; 155.000; -999.000; -999
这几列数据。并输出到excel中啊
哪个大侠帮忙啊
我是批处理新手,但需要处理大量的这样数据,求助各位大侠啊 |
|