1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Option Explicit
Const ForReading = 1, ForWriting = 2
Dim fso, Fich1, Fich2, Fich3, tb1, tb2, I, J
Set fso = CreateObject("Scripting.FileSystemObject")
Set fich1 = fso.OpenTextFile("Base.txt", ForReading, False)
Set fich2 = fso.OpenTextFile("Résultat.txt", ForReading, False )
Set fich3 = fso.OpenTextFile("Compared.txt", ForWriting, True )
tb1 = SPlit(Fich1.ReadAll, vbCrLf)
tb2 = Split(Fich2.ReadAll, vbCrLf)
Fich1.Close
Fich2.Close
For I = 0 To Ubound(Tb1)
For J = 0 To UBound(tb2)
If Left(Lcase(tb1(I)), Len(tb2(J))) = Lcase(tb2(J)) Then Fich3.WriteLine tb1(I)
Next
Next
Fich3.Close |
Partager