首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > .NET >

怎么读取这种文本到数据库中?(数据用写字板打开可看)

2013-08-04 
如何读取这种文本到数据库中?(数据用写字板打开可看)gltrrp.p AO25.13.21 Transaction RegisterDate: 25/0

如何读取这种文本到数据库中?(数据用写字板打开可看)
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键,这样好控制些。
[解决办法]
文件的内容看起来还是有规律的,只能自己逐行解析了。

热点排行