Show All Projects
This is a utility to compare whether lines of text are in both files or only one. I wrote this after I was asked to do what I considered to be an asinine manual task of recording inconsistencies between two sets of data. I had to write JavaScript to screen scrape one source, then use this program to compare it against the other.

From the utility itself, here's how it works:
Drag a file to each field and click the button. Breaking by Windows linebreaks (CRLF) it will look for lines in the first that match in the second. If matched they will be added to SharedLines.txt, but if in only one, they will be added to [Filename]-only.txt"


Timeline

Files

  BENCHMARKS  
Loading Time: Base Classes  0.2671
Controller Execution Time ( Project / Id )  0.4537
Total Execution Time  0.7225
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,077,760 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/17/Unique_Line_Diffs
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0039 seconds)  (Hide)
0.0006   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '17' 
0.0006   SELECT *
FROM `Projects`
WHERE `ProjectID` = '17' 
0.0009   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '17' 
0.0010   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0008   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)