File comparison is the process of comparing the contents of files, finding their common contents and their differences, usually using an automated tool

learn more… | top users | synonyms (1)

40
votes
4answers
5k views

Can software differentiate between a laptop and a desktop?

A license for CPU-intensive software like Pix4D says it can be installed on two devices - but with a condition. Reading the finer print, it seems that one device can be a full-processing ...
0
votes
2answers
23 views

How can I diff two files and get what is different in the second one as an output

What's easiest way to diff two files, check what is different in the second one and get it as output? I'm comparing two css files, and rest is the same only colors are different. PS: I also want to ...
1
vote
1answer
13 views

Document recovery dialog in MSWord

There is [Autosaved] and [Original] files in the Document Recovery dialog, which lets me to open one or both files and then save them. The problem is that the files are very large and I cannot see ...
1
vote
2answers
46 views

Find/check redundant files for cleanup and backup purposes

Very often I want to find out if the contents of given folders match or if the content of a single folder is redundant - maybe to check if it's duplicate and can be removed or to make sure there are ...
1
vote
1answer
24 views

Excel compare two different files and match similar fields and highlight the row

So I have two excel documents. First document with lots of fields and second with the fields that I an interested in. So I am looking to highlight the matching rows from second spreadsheet oo the ...
1
vote
2answers
39 views

How to rename a big collection of files numerically, ordered based on “Date modified”?

I am using Windows 7; I have about 1400 small images of type: *.png Each image has a random name, but it has a specific date it was created at; that is "Date modified". What I need to do is to ...
0
votes
2answers
90 views

Excel 2010 How to compare two sets of numbers that don't match but are related and return true/false result?

I am trying to compare two sets of numbers but they have different formats (the length of one number is different in each list) but parts of them match. I want to find the matches and return a YES ...
2
votes
1answer
37 views

Ram Compatibilty

I wish to upgrade my laptop from 6GB ram to 8GB ram. Currently installed is Type DDR3 Size 4096 MBytes Manufacturer Samsung Max Bandwidth PC3-12800 (800 MHz) Part Number M471B5173DB0-YK0 ...
-2
votes
1answer
23 views

Does a “website or organization devoted to neutrally test different computer model's perfomance” exist? [closed]

I want to buy a new computer to replace my 4 year old laptop. I must choose a particular computer (from now on pc) to buy. The information provided by computer vendors seems very confusing to me, and ...
0
votes
1answer
21 views

Compare documents (images)

I need to compare a pdf with about 27000 pages (scanned pages) to another pdf with about 28000 pages (also scanned pages) so that I can find the 1000 pages which differ. Does anyone now a good ...
1
vote
1answer
45 views

R: subset lines of a dataframe containing a string in another file

I would like to subset the lines of data frame 1 (df1) that contain a string from a column in data frame 2 (df2). The problem is that file1 will have multiple strings in the same column. I have tried ...
0
votes
1answer
49 views

Excel - compare cells of columns and delete row if they contain partly the same value

I try to delete rows of a CSV file, where two columns contain partly the same value, like this: ColA ColB ColC ColD mydom/users/michael mydom2\michael ...
1
vote
0answers
15 views

How to compare two PowerPoint (2010) text only like in word

Source (smart art, animation, formatting , casing) Draft (smart art converted to shape, changed formatting and casing, removed animation and transition and so on) While I trying a compare to in ...
0
votes
1answer
21 views

Comparing directories

At some point when there was a software upgrade the previous support person that I took over from made a copy of a directory to the new server for the upgrade. We've kept the old server around ...
1
vote
1answer
35 views

Calculate/determine in MS Excel which filetype/product has been ordered first (complex table)

I'm using MS Excel 2013 on a Windows desktop computer. The original worksheet I'm working on contains about 200,000 rows, or 4,000,000 cells, and is about people who downloaded a .pdf file, ordered ...
0
votes
1answer
234 views

Using value of cell to search text of another sheet and highlight cell if match is found

Scenario is a workbook with two sheets. I need a way for cells on sheet 2 to search sheet 1 and highlight themselves if they find any text on sheet 1 that matches. So cell sheet2!a2 with value of ...
0
votes
2answers
133 views

How to compare two cells in excel and output the matched cell content in specific format?

I need a formula that can do the following: compare cell A2 with All of column B if found multiple matches, then copy matched results that contains contents of cell A2 and output it in Cell D in ...
-1
votes
2answers
100 views

Same ip, different route?

There's a set of ip addresses that are hosted from the same ISP servers, but when i pick a random ip address from that set, it picks the right route or maybe the wrong one. I'll give you an example: ...
1
vote
1answer
96 views

Compare two word documents to show only similarities

I am working with two huge Word documents and I want to see only the similarities between. I have been using the compare function under the review tab however it is showing a lot of deletions and ...
-1
votes
1answer
97 views

BOM comparison sheet

I have been working on Comparison sheet, where i need to compare Base BOM1 with other BOMS. I added formula & prepared the attached sheet & I am able to highlight the mismatch values. But i ...
0
votes
2answers
103 views

Software that takes an image as input and searches a specified directory for similar images

I'm looking for a program that lets me input an image and then search a directory for visually similar images (much like Google image search, except it compares the image with my the local files in ...
1
vote
1answer
251 views

Data reconciliation with pivot table

I have 2 tables (table1, table2), each with 2 categorical variables/columns (product, country) and up to 5 real-valued variables to be reconciled/compared against each other (sales and other in the ...
0
votes
1answer
140 views

Compare/check multiple columns in multiple sheets and find the unmatched values

I have two sheets in libreoffice calc, both sheets have same columns, i need to compare these sheets column values(multiple columns) and need to check rows are equal, if not equal then need to ...
0
votes
2answers
76 views

Excel - Matching data across 2 separate workbooks

I have 2 separate tabs (tab A and Tab B) on a Workbook that both contain the column called CustomerID - this contains a unique Customer ID number. On Tab A it is Column B, on tab B it is under column ...
0
votes
0answers
65 views

Is there any way to tell a if backup is complete?

I lost a disk. It's clicking, which seems to be something almost everyone agrees is not very fixable. I have backups. Problem is, I look at the backups and the first thing I think is "Is that all I ...
0
votes
0answers
147 views

Compare value from one cell with other sheets with different names

i have a workbook, where i create one sheet per employee, the sheet is named after the employee. The sheet has two columns Variable and Values. The Variables will differ for departments I create a ...
0
votes
2answers
189 views

How to compare Word Documents (Unknown relation)

How do I compare two word documents that are related, but I do not know exactly how. (Different filenames, different filesizes) Everything I can find about comparing seems to be abut different ...
1
vote
3answers
82 views

I want to compare two columns in excel having 500000 records

I have two columns in excel file having almost 500000 records in each col. I want to check how many records from col 1 are present in col 2. I'm using below formula: ...
1
vote
0answers
27 views

How to extract only missing records from two given spreadsheets? [closed]

I have been provided with two spreadsheets, the first spreadsheet contains information about the member and the other contains the attendance on a particular day. Both have a common unique field which ...
0
votes
1answer
316 views

Compare the state of my system before vs. after software installation

I'd like to compare the state of my system before and after the installation of a given software. I've tried to do it with Windows System State Analyzer but the diff hangs after a few minutes and ...
1
vote
1answer
75 views

How can I quickly compare two directories skipping hard linked files that exist in both directories in linux

I have two directories that I would like to compare. The first directory contains an rsync backup of many thousands of folders and files. The second directory contains hard links to all of the files ...
0
votes
0answers
20 views

Compare two folders and update changes

I recently replaced a dying server for a client and migrated all of his stuff to a NAS. While I was copying data he and his employees were making changes on the server. I have the bulk of the data ...
0
votes
1answer
556 views

Use Excel to calculate similarity between two strings [duplicate]

Is there any way to calculate the % difference between two strings in Excel? For example, oftentimes a customer sends us a list of items that they want us to match with items in our system based on ...
1
vote
1answer
1k views

How to compare the contents of two pst files that check the same email address?

Is it otherwise possible to automate the comparison of two pst files? Here's my situation... A soon-to-be ex-employee brought his laptop in so that the contents could be copied/backed up (it was a ...
0
votes
1answer
37 views

How to compare those (date) values in bash

I need to compare 2 strings of the following formatting: 2013-12-31T00:00:00 2014-11-19T15:40:30 Its a custom datetime format. I tried different things, none worked: if [ ${val1} < ${val2} ] || ...
2
votes
3answers
1k views

Notepad++ Compare plugin doesn't highlight line changes anymore

I have 2 PCs at work, one with older version of Notepad++ (6.1.7) and one with newer version (6.5.3) and I use it frequently to quickly compare pieces of code or any other strings (I use WinMerge or ...
0
votes
2answers
172 views

How to compare two columns with other two columns for duplicates in Excel

I need to compare columns C and D with A and B and only if exist same combination of two cells in one row. Hope the image below will explain the situation better.
0
votes
1answer
103 views

excel: compare 3 column's numbers, decide on the largest number and place the column header in the 4th column

i want to compare the numbers of three columns, row by row, decide on the largest number and then place the title of the column of the largest number in a fourth column. the fourth column will end up ...
0
votes
1answer
184 views

How to compare databases?

I tried using meld on two dumps from two different databases from the same RDBMS, but it seems that those dumps are not comparable because not being canonical. I tried both pg_dump ... (standard) and ...
0
votes
1answer
36 views

Compare 1 column with 3 others and extract values from col1 that do not appear in other cols

Hey I have column A that has a list of text values, and have columns B,C,D which contain some of the same text values. I want to extract the values from Column A which do not appear in column B,C or ...
0
votes
1answer
139 views

Comparing files in two folders with different hierarchies and renamed files

I had a folder on my PC, and copied it to my laptop. Since than, I have changed some files on each of the folders (file modification, renaming, putting into folders an vice versa). How can I re-sync ...
8
votes
1answer
23k views

Compare two excel files

I need to compare two Excel Spreadsheets to see if values of each user in a specific column were changed. The new Spreadsheet may have additional users that were added making the row old users ...
0
votes
2answers
424 views

How can I binary compare two large files in Windows?

I have two 4GB temporary files. I did a quick visual inspection using a hex editor and see they appear to be the same. Is there a command I can use in something like PowerShell to binary compare the ...
2
votes
2answers
381 views

Comparing folders on two unconnected computers

I'd like to compare folders on two different computers. I'm using BitTorrent Sync to synchronize currently 260 GBs of data between two computers: a Windows 7 desktop PC and a Windows 8.1 laptop. All ...
2
votes
1answer
127 views

remove duplicate lines after first word in sentace linux terminal

I was looking to remove duplicates of lines of text but after a space from the first word in this format; apples blue apples green apples are sometimes red pairs green pairs black potato brown lemon ...
1
vote
1answer
404 views

2 large text files, find the lines that are not duplicate linux terminal

I am looking to find lines that are not duplicate, example; Text file 1: cats 3 dogs 8 mice 4 pigs 10 ... Text file 2: dogs 8 mice 4 cats 78 pigs 29 bird 6 ... Cats and pigs simply got changed ...
1
vote
1answer
59 views

How to highlight all keywords in a piece of text?

We are using a large common spammer phrase list as part of our spam filtering system. Any matches in the subject or message body of an email cause it to go straight to our Office 365 hosted ...
0
votes
1answer
33 views

How can I compare effective power usage of two CPUs / CPU+Mobo+Mem combinations?

I have this server which does mostly file sharing (with the associated storage). No serious number crunching and it isn't the firewall. My current box has a Celeron D processor (Prescott 336 2.8 GHz); ...
0
votes
0answers
174 views

How to find similarities in two text files?

Given two text files, how can I find passages that are alike? I know that I can use Meld or another diff tool to show the differences, but how to do the reverse thing? For example, here are two texts ...
0
votes
0answers
54 views

batch files compare before and after before deleting

I use two commands in this batch file for /r %%n in (*.wav) do xma2encode "%%n" for /r %%n in (*.wav) do del "%%n" Sometimes xma2encode doesn't create the .xma file like it is supposed to. If it ...