Sunday, 15 April 2012

Single Column Data Compare between two files

How to get this Script

Please send Email with Subject "Single Column Compare"  to vijkid143@gmail.com for Zip File

Note: Customization can be done on Request


Description
This Script will compare the data between two files having Single Column with multiple records




How to Use it
1) Download the zip file (Please send Email with Subject "Single Column Compare"  to vijkid143@gmail.com for Zip File)
2) Unzip the Files
3) Fill the values which are to be compared in File1 and File2 which acts as Input Files
4) Run the Script GET_MATCHING_RECORDS_OF_FILE1.vbs
5) Once script execution is completed. Open the Matches and NoMatches files
6) Matches File will have the common values between two input files
7) NoMatches file will have the "Records present in File1 not present in File2"


Note: To find out the "Records present in File2 not present in File1". Run the other script "GET_MATCHING_RECORDS_OF_FILE2.vbs" which works the otherway roundd

Visit Youtube Video for clear information
http://www.youtube.com/watch?v=cIrMZCLz3II


Visit My Other Blogs

http://exceljoins.blogspot.in/
http://wordcount-vbscript.blogspot.com/

Developed By: Vijay Uppara (Vijaya Bhasker M Uppara) 

Please send your comments or Feedback to vijkid143@gmail.com
 




No comments:

Post a comment