Compare two CSV files in vbscript -

i have write vbscript compare 2 csv files,

the both csv files contains following data format, file1.csv

dbnane usergroup path                 access db_1    dev_ii   db/source/projects   read/write db_2    test_i   db/source/doc        read

file2.csv

dbnane usergroup path                 access db_1    dev_ii   db/source/projects   read db_2    test_i   db/source/doc        read

i need compare these files, output format like,

file3.csv

dbnane usergroup path                 access db_1    dev_ii   db/source/projects   read/write

i'm new vbscript. sample script ? thanks.

in powershell differing lines 2 text files this:

$f1 = get-content 'c.\path\to\file1.csv' $f2 = get-content 'c.\path\to\file2.csv'  compare-object $f1 $f2

if need show what's different in first file ($f1), filter result this:

compare-object $f1 $f2 | ? { $_.sideindicator -eq '<=' } | % { $_.inputobject }

Copy