cread
Sep 19th, 2000, 08:06 PM
I am having a bit of a problem, perhaps someone might have a few ideas.....
I am trying to convert data from a txt file which is in the following format:
"143" "2007800002" 6 "0009924" "04105"
"L2/BUP12461" 2 "" "BUP12461" "L2 BUP12461:PAR WOORIM" "" ""
The data comes in pairs of lines like above and I can have up to 5000 of these in the one file that needs to be converted. The feilds are separated by a space. The feilds marked with "" are strings and ones without are integers. The tricky part now is that the table that the second line is to be converted is represented by the third feild of the top line (this feild is not placed in the database)
Any insight you can give towards this problem would be greatly appreciated
Regards
Clayton Read
claytonread@hotmail.com
I am trying to convert data from a txt file which is in the following format:
"143" "2007800002" 6 "0009924" "04105"
"L2/BUP12461" 2 "" "BUP12461" "L2 BUP12461:PAR WOORIM" "" ""
The data comes in pairs of lines like above and I can have up to 5000 of these in the one file that needs to be converted. The feilds are separated by a space. The feilds marked with "" are strings and ones without are integers. The tricky part now is that the table that the second line is to be converted is represented by the third feild of the top line (this feild is not placed in the database)
Any insight you can give towards this problem would be greatly appreciated
Regards
Clayton Read
claytonread@hotmail.com