---------------------------------------------------------------------------------
|459349     NB   M522                           公司             P12 2010.08.16 |
|  00060 PRDARA123WJZZ      放热板                                   N          |
|        NP2  R171                3,465.000  PC            5.43  RMB       1 PC |
|     仍要交货                        0.000  PC            0.00  RMB     0.00 % |
|     仍要开票                        2.000  PC           10.86  RMB     0.06 % |
|461108     NB   M522                           公司             P12 2010.08.30 |
|  00040 CCHSM3456TPN2      背板                                     C          |
|        NP2  R100                1,470.000  PC          161.99  RMB       1 PC |
|     仍要交货                        0.000  PC            0.00  RMB     0.00 % |
|     仍要开票                    1,470.000  PC      238,125.30  RMB   100.00 % |
---------------------------------------------------------------------------------
TXT内容如上，我要提取结果例：459349,NB,M522,公司，P12，.....2.000,PC,10.86,RMB,0.06%

那我想知道怎么能吧TXT中的“|”和“---------------------------------------------------------------------------------”去掉？

我的原意是想把这些数据重新排列，然后放到ACCESS里。难搞啊！！

谢谢了~~

459349,NB,M522,公司,P12,2010.08.16
00060,PRDARA942WJZZ,放热板,N
NP2,R171,3,465.000,PC,5.43,RMB,1,PC
仍要交货,0.000,PC,0.00,RMB,0.00%
仍要开票,2.000,PC,10.86,RMB,0.06%
461108,NB,M522,公司,P12,2010.08.30
00040,CCHSM0074TPN2,背板,C
NP2,R100,1,470.000,PC,161.99,RMB,1,PC
仍要交货,0.000,PC,0.00,RMB,0.00%
仍要开票,1,470.000,PC,238,125.30,RMB,100.00%
461508,NB,M522,公司,P12,2010.09.02
00010,CANGKB414WJ01,金属框架,C
NP2,R171,89.000,PC,13.72,RMB,1,PC
仍要交货,0.000,PC,0.00,RMB,0.00%
仍要开票,89.000,PC,1,221.08,RMB,100.00%
00020,CANGKB414WJ02,金属框架,C
NP2,R171,89.000,PC,18.59,RMB,1,PC
仍要交货,0.000,PC,0.00,RMB,0.00%
仍要开票,89.000,PC,1,654.51,RMB,100.00%

现在变成了这个样子，我怎么在TXT中取几个数据呢，比如我要取459349，00060，PRDARA942WJZZ，仍要交货,0.000,PC,0.00,.......