在VF里面打开文本文件:modi comm filename.txt(例;modi comm yyy702.txt)
逐步分析表:
先建一个字段(可预见类型及长度的)及一个长的字段(待分解)
creat yy612
appe from yyy612.txt
appe from yyy612.txt sdf
use yy612
appe from yyy612.txt sdf
appe from yyy702.txt sdf
brow
modi stru
appe from yyy702.txt sdf
brow
modi stru
zap
appe from yyy702.txt sdf
brow
modi comm 702
用程序段实现数据处理:
set safe off
use yyy611
zap
copy stru to yyy702
use yyy702
appe from yyy702.txt sdf
select dhhm ,t,count(t) as ll,sum(ydf)+sum(ctf) as fy,sum(ydf) as xxf,sum(ctf) as yzf from yyy702 group by dhhm,t into table yyy702tj
copy to yyy702tj.txt sdf
delete file yyy702tj
将一个DBF表的表结构导出txt或xls文件:
USE 表名
COPY TO EXCEL文件表名.XLS TYPE XL5/XLS
copy to sp1.txt type sdf
&&是真正转换成文本,要显示内容,用:
type sp1.txt