Sunday 1 September 2013

Identify the Duplicate Values and Distinct Values in a Flat File

How to get this Script

Please send Email with Subject "Identify the Duplicate Values and Distinct Values"  to vijkid143@gmail.com for Zip File 


Note: Customization can be done on Request

Description
1) This Script will identify the Duplicate Values which are present more than once in a File and will give the Count of the each Duplicate Value.

2) It also shows the Distinct Values


How to Use it
1) Download the zip file (Please send Email with Subject "Identify the Duplicate Values and Distinct Values"  to vijkid143@gmail.com for Zip File)
2) Unzip the Files
3) Fill in the input values in a Sorted Order in File1 from which the Duplicate values have to be identified
4) Run the Script GET DUPLICATE RECORDS.vbs
5) Once script execution is completed. Open the "1.DUPLICATES.txt" and "2.DISTINCT_VALUES_WITHOUT_DUPLICATES.txt" files
6) 1.DUPLICATES,txt File will have all the values which are present more than once in the Input File. In Summary section it also it will show the total count of values which have duplicates
7) 2.DISTINCT_VALUES_WITHOUT_DUPLICATES.txt will have all the distinct  values which are present in the Input File, In Summary section it also it shows the total count of Distinct values.

Youtube Video
http://www.youtube.com/watch?v=MPv5r-wfgzg

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






2 comments:

  1. well done! very easy. thank you!

    ReplyDelete
    Replies
    1. Thanks for using this Script...You can Visit http://datacompare.blogspot.com/ for more Scripts.

      Delete