Hi to all
I wonder how to acomplish the following:
I have a text file (comma delimited) with the following format:
1st colum is a 4 digit number (ie 9999)
2nd column is a 4 digit number denoting the time (ie. 1235 which is 12.35)
3rd column is a 8 digit number denoting the date (ie. 11092000)
4th column is a one digit character which holds the flag (ie O = Out , I = In)
Need to append a table with the following fields
code ,c,10
timein ,c,6
timeout ,c, 6
date ,c, 8
if the flag equals O the data should go to timein
if the flag equals I the data should go to timeout
I have tried various techniques but no success.
Any ideas?
Thanking you in advance
Regards
Mike