I’d really appreciate if someone could help me out with the following:
I have a folder full of text files with part numbers in them as below:
Note that the * indicates part numbers which are the same in two customers files.
[quote]Customer1.txt
163485
459279*
498573[/quote]
etc…
[quote]Customer2.txt
895725
939058
459279*[/quote]
etc…
I have another text file which contains all of the part numbers ever used by any customers.
[quote]PartNumbers.txt
895725
939058
163485
459279
498573[/quote]
etc…
I can manually use ‘Find in Files’ and it creates a great set of results, for each individual number - telling me the customer file it is located in and a total of how many times it is used.
Is it possible to display these results differently, telling me how many times it was used in total and then list the customer text file name underneath? Ideally it would loop through “SerialNumbers.txt” and produce one report.
My ideal output would appear as this (in this small example):
[quote]Results.txt
895725 (1)
Customer2.txt
939058 (1)
Customer2.txt
163485 (1)
Customer1.txt
459279 (2)
Customer1.txt
Customer2.txt
498573 (1)
Customer1.txt[/quote]
I don’t need to know where in the customer files the part number is.
Any help would be grealy appreciated. I’m currently only testing Sublime Text 2 but so far I am very impressed.