如何读取这种文本到数据库中?(数据用写字板打开可看)
gltrrp.p AO 25.13.21 Transaction Register Date: 25/03/13
Page: 1 PROD HUSQVARNA HEBEI Time: 09:17:29
Line Account GL Reference Description Base Amount Currency Amount Cur Address T Document Matching
----- -------------- -------------- ------------------------- ------------------ ------------------ --- -------- -- ---------------- --------
1 5700RMB AP130304001450 AP Checks -150.00 -150.00 CNY CASX CK 00390
2 44000XX AP130304001450 长安区胜兴机电产品经 150.00 150.00 CNY CASX CK 00390
1 5500100 AP130304001451 AP Checks -38,012.54 -38,012.54 CNY CASX CK 10391
2 44000XX AP130304001451 长安区胜兴机电产品经 38,012.54 38,012.54 CNY CASX CK 10391
1 5500100 AP130304001452 AP Checks -254,110.74 -254,110.74 CNY HHJX CK 10392
2 44000XX AP130304001452 石家庄弘航机械制造有 254,110.74 254,110.74 CNY HHJX CK 10392
1 5500100 AP130304001453 AP Checks -30,455.50 -30,455.50 CNY KYBZ CK 10393
2 44000XX AP130304001453 石家庄飞阔贸易有限公 30,455.50 30,455.50 CNY KYBZ CK 10393
1 5500100 AP130304001454 AP Checks -198,323.83 -198,323.83 CNY HXJX CK 10394
2 44000XX AP130304001454 藁城市世通机械有限公 198,323.83 198,323.83 CNY HXJX CK 10394
1 5500100 AP130304001455 AP Checks -83,001.00 -83,001.00 CNY JLJX CK 10395
2 44000XX AP130304001455 藁城市建利机械有限公 83,001.00 83,001.00 CNY JLJX CK 10395
1 5500100 AP130304001456 AP Checks -37,808.64 -37,808.64 CNY CZCHWJ CK 10396
2 44000XX AP130304001456 沧州庆辉五金制品有限 37,808.64 37,808.64 CNY CZCHWJ CK 10396
1 5500100 AP130304001457 AP Checks -9,312.22 -9,312.22 CNY HXCC CK 10397
2 44000XX AP130304001457 石家庄经济技术开发区 9,312.22 9,312.22 CNY HXCC CK 10397
1 5500100 AP130304001458 AP Checks -36,569.79 -36,569.79 CNY WXJG CK 10398
2 44000XX AP130304001458 伟欣激光技术有限 36,569.79 36,569.79 CNY WXJG CK 10398
1 5500100 AP130304001459 AP Checks -4,051.79 -4,051.79 CNY YDRCL CK 10399
2 44000XX AP130304001459 石家庄市毅德热处理有 4,051.79 4,051.79 CNY YDRCL CK 10399
1 5500100 AP130304001460 AP Checks -9,309.00 -9,309.00 CNY JLJX CK 10400
2 44000XX AP130304001460 藁城市建利机械有限公 9,309.00 9,309.00 CNY JLJX CK 10400
1 5500100 AP130304001461 AP Checks -985,584.62 -985,584.62 CNY CNX CK 10401
2 4401CNX AP130304001461 克石通金刚石(厦门) 985,584.62 985,584.62 CNY CNX CK 10401
1 5500100 AP130304001462 AP Checks -142,680.00 -142,680.00 CNY WDJD CK 10402
2 44000XX AP130304001462 文登奥文机电设备有限 142,680.00 142,680.00 CNY WDJD CK 10402
1 5500100 AP130304001463 AP Checks -298,565.30 -298,565.30 CNY HXXF CK 10403
2 44000XX AP130304001463 辉县市新福模具厂 298,565.30 298,565.30 CNY HXXF CK 10403
1 5500100 AP130304001464 AP Checks -157,920.40 -157,920.40 CNY HXDJC CK 10404
2 44000XX AP130304001464 河北冠都机械有限公司 157,920.40 157,920.40 CNY HXDJC CK 10404
gltrrp.p AO 25.13.21 Transaction Register Date: 25/03/13
Page: 2 PROD HUSQVARNA HEBEI Time: 09:17:29
Line Account GL Reference Description Base Amount Currency Amount Cur Address T Document Matching
----- -------------- -------------- ------------------------- ------------------ ------------------ --- -------- -- ---------------- --------
1 5500100 AP130304001465 AP Checks -2,700.00 -2,700.00 CNY BJJBL CK 10405
2 44000XX AP130304001465 北京金宝利科贸有限责 2,700.00 2,700.00 CNY BJJBL CK 10405
1 5500100 AP130304001466 AP Checks -74,800.00 -74,800.00 CNY CZCHWJ CK 10406
2 44000XX AP130304001466 沧州庆辉五金制品有限 74,800.00 74,800.00 CNY CZCHWJ CK 10406
1 5500100 AP130304001467 AP Checks -42,000.00 -42,000.00 CNY JYNM CK 10407
2 44000XX AP130304001467 江油核宝纳米材料有限 42,000.00 42,000.00 CNY JYNM CK 10407
1 5500100 AP130304001468 AP Checks -18,000.00 -18,000.00 CNY LWJS CK 10408
2 44000XX AP130304001468 莱芜市金石特种合金材 18,000.00 18,000.00 CNY LWJS CK 10408
1 5500100 AP130304001469 AP Checks -82,050.00 -82,050.00 CNY YHMJ CK 10409
2 44000XX AP130304001469 桥西区凯瑞德机械配件 82,050.00 82,050.00 CNY YHMJ CK 10409
1 5500100 AP130304001470 AP Checks -18,450.00 -18,450.00 CNY HHXF CK 10410
2 44000XX AP130304001470 河南黄河旋风股份有限 18,450.00 18,450.00 CNY HHXF CK 10410
1 5500100 AP130304001471 AP Checks -34,818.00 -34,818.00 CNY SZHFT CK 10411
2 44000XX AP130304001471 苏州福田高新粉末有限 34,818.00 34,818.00 CNY SZHFT CK 10411
1 5500100 AP130304001472 AP Checks -41,215.38 -41,215.38 CNY GCHFSM CK 10412
2 44000XX AP130304001472 藁城市恒丰石墨制品有 41,215.38 41,215.38 CNY GCHFSM CK 10412
1 5500100 AP130304001473 AP Checks -78,900.00 -78,900.00 CNY HXDJC CK 10413
2 44000XX AP130304001473 河北冠都机械有限公司 78,900.00 78,900.00 CNY HXDJC CK 10413
1 5500100 AP130304001474 AP Checks -128,119.54 -128,119.54 CNY HXHY CK 10414
2 44000XX AP130304001474 辉县市环宇模具制造有 128,119.54 128,119.54 CNY HXHY CK 10414
1 5500100 AP130304001475 AP Checks -95,946.21 -95,946.21 CNY DYRF CK 10415
2 44000XX AP130304001475 丹阳市荣丰通讯器材厂 95,946.21 95,946.21 CNY DYRF CK 10415
1 5500100 AP130304001476 AP Checks -333,628.52 -333,628.52 CNY XHDH CK 10416
2 44000XX AP130304001476 香河县高氏印务有限公 333,628.52 333,628.52 CNY XHDH CK 10416
1 5500100 AP130304001477 AP Checks -93,075.53 -93,075.53 CNY XXYSD CK 10417
2 44000XX AP130304001477 雄县亿顺达服装辅料厂 93,075.53 93,075.53 CNY XXYSD CK 10417
1 5500100 AP130304001478 AP Checks -108,549.62 -108,549.62 CNY XHDH CK 10418
2 44000XX AP130304001478 香河县高氏印务有限公 108,549.62 108,549.62 CNY XHDH CK 10418
1 5500100 AP130305001479 AP Checks -97,800.00 -97,800.00 CNY WYNJ CK 10419
2 44000XX AP130305001479 藁城市伟诚机械厂 97,800.00 97,800.00 CNY WYNJ CK 10419
gltrrp.p AO 25.13.21 Transaction Register Date: 25/03/13
Page: 3 PROD HUSQVARNA HEBEI Time: 09:17:29
[解决办法]
一行行读出来,然后解析,和数据库里面的表栏位对应起来,保存到数据库,我们的程式和其他程式的接口程式是这么做的。
[解决办法]
文件内容不标准, 无法用现成控件完成转化工作.
可以用Tstringlist之类的读入文件内容, 逐行拆解, 然后写入数据表.
(看了下列名下的'-'数目对应你字段长度)
[解决办法]
按行读取,用空格来判断各字段
[解决办法]
我现在的程式用的TAB键,这样好控制些。
[解决办法]
文件的内容看起来还是有规律的,只能自己逐行解析了。