现在有个文件,文件名是20090923161900_01_1.txt,里面内容是:
DC91D10E,DFC2233E000104E0,3135385A303533362D303120202020202020202030382D31333831202020202020202020,6EC2233E000104E0,313538533753483237532020202020202020202048323039303120202020202020202020
我想把这个文件内容读到SQL 数据库中,并以如下显示:
Date     YYYYMMDD (20090923)
Time HH:MM:SS (16:19:00)
ID1 01
ID2      DC91D10E (需要转成ASCII码)
Tag ID DFC2233E000104E0 / 6EC2233E000104E0 (需要转成ASCII码)
Content 3135385A303533362D303120202020202020202030382D31333831202020202020202020 / 313538533753483237532020202020202020202048323039303120202020202020202020 (需要转成ASCII码)
其中content需要分2列显示,一列叫content1, 就用前20位(对应16进制就是前40位);还有一列叫content2, 就用后16位(对应16进制就是后32位)。请各位帮忙解决,感激不尽先!