Hi, What is the best way to compare two files and write the unmatched values to a new txt.
File A = Patches required File B = Patches installed
I need to compare the values in file A to file B. The values that do not exist in file B compared to file A are written to a new txt. Additional layer to this problem values in B may look like this "Package_for_KB2823180~31bf3856ad364e35~x86~~6.1.1.0" and the value in file A would be "KB2823180". I searched the forums and just got more confused.
Glenn BarnasGlenn Barnas KiX Supporter
Registered: 2003-01-28
Posts: 4403
Loc: New Jersey
There are several methods but here's something simple..
Load each file into an array - look at the FileIO UDF -
Code:
$Array = FileIO('filename', 'R')
Call this once for each file, using different names for the $Array variable ($aNeed and $aHave, for example) and source filename.
Enumerate the "have" array, locate the matching record in the Need array and clear that value.
Code:
For Each $Patch in $aHave
$E = AScan($aNeed, $Patch) ; look for the current patch in the NEED array
If $E >= 0 ; will be -1 if not found
$aNeed[$E] = '' ; clear the value from the NEED array
EndIf
Next
The $aNeed array will contain only the missing patches.
Optionally, use the QS or QSort UDF to sort the array. Save the resulting array.
Glenn BarnasGlenn Barnas KiX Supporter
Registered: 2003-01-28
Posts: 4403
Loc: New Jersey
Jay,
Glad it worked! (and thanks for the follow-up!)
Check the AScan manual page - you'll find that there's an option to find a substring match, which might let you reverse the search logic and not have to edit your data.
Since the HAVE array has more text than the NEED array, you could enumerate the NEED array instead, using the substring flag of AScan. You'd then clear the enumerated element instead of the found element - AScan would simply indicate a match without caring where it matched. To do this, you'd need the form For $I = 0 to UBound($aNeed) so you have a reference to the index of the enumerated array. A For Each $ in $Array won't let you modify the enumerated array.
Just some thoughts on an alternative method...
Glenn
_________________________ Actually I am a Rocket Scientist!
