Read text file
Posted on 2004-03-24
Sorry i haven't many more points left, so it is only going to be 135.
What i want to do is read every file .txt in a directory eg, c:\text\*.*
Each file is uniquely numbered.
124textfile.txt etc etc
Inside each text file is the following:
| (0008,0022) : DA Len: 8 AcquisitionDate Value: 
| (0008,0029) : DA Len: 8 AcquisitionTime Value: 
this can have LOADS of lines,
what i want for example is to find the line with the number 0008,0022 and copy the value "20020121" into a SQL database, using also the file name as the entry.
However i want to add more than 1 into the database so i could say........................
Copy 0001,0034 and 0022,4733, and also 1234,4443 data into database,
Please guide me into the right direction, just to end up with the var of the result for example at least.
More points will be awarded as i get them