I have two files of CSV and would like to merge into one file with out exchanging info.
1st csv (or text file) has info in two columns. (i.e, file names, member revision 1)
2nd csv (or text file) has info in two columns. (i.e, file names, member revision 2)
I would like to have the 3rd CSV by merging/adding two files.
So that the output be in 3 columns,
o/p in CSV: file name; member name 1; member name 2
it should compare the file names of the of two files and if they repeat then take that file name in 1st column with member rev 1 in 2nd column and mem rev 2 in 3rd column.
&&& if they dont repeat the name then also take the file name and write in 1st column with repesctive mem revision.
i mean if thhis fil name is from 2nd file then it contains only mem rev 2,
So in the output file should be like file name in 1st column, 2nd column should be blank, 3rd column should fill with mem rev 2.
I have 2 csv files with information.
1st: contains file names and versions.
2nd: contains file names and versions.
Putüput should be: file name; mem rev 1; mem rev 2 (in 1st, 2nd & 3r columns in CSV file)
COM 1.1 1.2
CAD 2.1 2.2
SAD 3.1 --
MOD -- 4.1
Please help me. its very urgent, it can save my job.
I am sorry if i couldnt give you ppl much info.
Thanks in advance