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)

0
votes
0answers
18 views

How to Compare Files in HDDs

I made backup of my external HDD (I call it HDD1) on another HDD (I call it HDD2). The two HDD are the same physically, same model. My problem is that the HDD2 has less of the HDD1 file. Something was ...
0
votes
0answers
21 views

Comparing date in google spreadsheet

I am trying to compare dates in a column to the current date using the script below but it gives me undefined status var toDay = new Date(); if (row[8] = toDay) {Department == "CRM";} ...
-1
votes
1answer
31 views

Compare 2 sets of data in EXCEL and return what it should be

I need some help with comparing 2 sets of data in Excel (see screenshot below). As you can see I have data from 2 sources. Source 1 is the correct data. Source 2 may have been correct at some point ...
1
vote
2answers
157 views

What is faster: Intel's Optane SSD or RAM?

Time ago here was a question about speed comparison between SSD and RAM. So, RAM was much faster. It's ok. But Intel announced huge speed update with Optane SSD's. So, and probably we should try to ...
1
vote
0answers
22 views

Spreadsheet Compare with locked/hidden cells

I created a worksheet in Excel 2013 with several tabs. There are a number of values and formulas we do not want users seeing or playing with. Most of the cells are locked and hidden. Several of the ...
0
votes
1answer
52 views

Notepad++ Compare Plugin has lines of unequal size

I am using Notepad++'s "Compare" plugin - which is incredibly useful for comparing code chunks... however I have just recently noticed that while using this handy tool, the lines do not line up side ...
0
votes
0answers
38 views

Merging MP3 meta-tag info from multiple copies of the same song

diiI'm consolidating libraries of MP3 music. The same song (identical bit rate, encoding frequency) is in different libraries differing only in the meta-tag data. The duplicates songs all copies of ...
0
votes
0answers
28 views

Robocopy e Compare Commands

I have two problems. I used ROBOCOPY to backup my external HDD in another external HDD. After skipping Error 2 and Error 5 using the following line: C:\>robocopy E: G: /e /r:3 /w:1 /sec /mir /z /...
3
votes
2answers
124 views

diff stop after first difference

I'd like to perform a diff on 2 files and have it cease at the first difference. I don't require that the command be done via diff, of course, but I do require that the actual command cease once the ...
41
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 workstation/...
0
votes
2answers
32 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
16 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
66 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
59 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
54 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 re-...
0
votes
2answers
173 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
62 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
25 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
23 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
161 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
92 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
16 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
23 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
39 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
572 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
267 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
154 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
175 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
158 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
150 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
449 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
293 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
90 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
76 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
203 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
412 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
95 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: =IF(ISERROR(MATCH(A1,$D$1:$D$...
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
465 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
2answers
113 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
825 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
2k 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
39 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
2k 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
208 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
280 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
261 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
41 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 D....
1
vote
1answer
161 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 ...