>>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
>>
>
>If the source file is not huge, you can get it to string with FILETOSTR(), then to array with ALINES() and get this line.
>
>That's a quick idea and it may be not the most efficient way.
>
>Another way would be to get this file into the cursor / table (using APPEND from TYPE SDF).
Do you have the ability to read my mind?
To Jay: Using VFP, you and also create a cursor, append from the log file with CSV, and simply GOTO the line in question.