Quote:

Thanks Bryce, i will give it a shot........




hmm i just read, your post regarding kix version and sample file data...

be sure to isolate the SSN from the $line variable in the for next loop before running the ascan() command.

Making the assumption that fileB data is like the following...

Code:

123-45-6789,smith,bill,1313 mocking bird lane,blahh..,blah,blah



you will need to isolate the SSN first.

if it is comma delimited.... and the SSN is the first data field...

Code:

For Each $line In $fileB
If AScan($filea,split($line,",")[0])+1
? "A SSN In file b was found In file a, writting the line To file c"
$ = WriteLine(1,$line+@CRLF)
EndIf
Next



Bryce


Edited by Bryce (2004-08-16 06:02 PM)