Hi Jay,
as your source is comma seperated, you could create a cursor based on the source's structure and then use append from ...csv. Afterwards, all you'd have to to would be to point to the record as it is identical to the error line.
>I'm trying to find a way to look for all lines in a log file that had errors and then look in the source file to extract the actual line that was processed, causing the error. Finding the occurrences of the errors and extracting out the line number isn't too tough, but how then to get to that line in the 2nd file?
>
>
>Log File:
>
>06/25/2008 3:08:22 PM Error Line 1531 - Syntax error or access violation
>
>
>Source:
>
>3224,Medical History,PT'S MEDICAL RECORDS,20080328,EXP_00FCDB0001.TIF
>
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011
