Questions tagged [comparison]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Using fpcalc to compare two audio files

I wish to compare two audio files in order to determine wether they are encodings of the same audio or not. The fpcalc utitlity, which is built on the chromaprint library, can be used to fingerprint ...
user avatar
  • 391
0 votes
1 answer
15 views

how do I compare dates separated by semicolon in same cell in excel

This is my data in column A. I want to compare dates with each other separated by semicolon to see if they all match or not and put the answer in another column saying match or no match. How do I do ...
user avatar
  • 3
0 votes
1 answer
24 views

Excel: How do I compare 4 columns with repetitions?

I have 4 columns. A,B,X,Y. How do I compare all 4? I want to create column Z where if A == X and the corresponding value B == Y, the result is 1. It is zero otherwise, how do I do that? Thanks A B X ...
user avatar
  • 3
0 votes
0 answers
16 views

Cross-compare several files with a diff tool

Have anyone encountered the challenge of comparing several files with each other on a Mac/unix machine? Consider a list of files 100.txt, 101.txt, 102.txt etc. in the same folder. How can I cross-...
user avatar
2 votes
2 answers
311 views

How to compare two hard drives (or folder) to find missing files in one of them?

I'm on macOS and, for context, I have one main hard drive that should include all my files (and yes, it's backed up with redundancy). And I have many other smaller hard drives that I have used over ...
user avatar
0 votes
1 answer
26 views

Compare two excel files to change elements in cells

I have two excel files, A and B. A is a dataframe with a header. B has two columns, the first one has the original name and the second one has new name A: sam1 sam2 sam3 sam4 .... p1 0 1 2 ...
user avatar
0 votes
1 answer
227 views

Excel VBA - Dealing with Overlapping Times

I have a really big table in Excel that has multiple rows where each row contains a comparison between two employees that had worked over the same time. See examples of some sample rows in the image ...
user avatar
1 vote
2 answers
364 views

How do I find common lines in two files

Let's say I have: text.txt with 1 2 3 4 5 and another text2.txt with 9 4 2 1 7 And I want to extract the duplicates: 2 1 4 Note: I'm using windows, I want it to be as easy as possible
user avatar
0 votes
0 answers
77 views

Comparing Files to a list of MD5 Hashes and getting a List as Result (where i can delete, copy, cut etc. the results)

I am searching for a solution for the following situation. I have a list of Hashes in a Text File and i want to find every File in a certain folder and subfolders that matches the Hashes from the Text ...
user avatar
  • 1
0 votes
1 answer
16 views

One Cell number to compare in multiple rows

I have ID in Col A and Remarks in Col B. I need to Return status in Col C. If Remarks against any specific ID is all Approved, it should show in status as "Approved". If All remarks against ...
user avatar
0 votes
1 answer
185 views

How to compare two videos and get timestamp(s) of differing frame(s)?

I've got rips of two copies of the same physical DVD. There's a difference between the two disc images - one of the videos files has a small binary diffence. I suspect one of the discs has physical ...
user avatar
  • 193
0 votes
1 answer
395 views

Excel formula to return value based on header and two columns

I'm trying to write an Excel formula that will place an "X" in a cell if the value in the header row occurs anywhere in column A while the values in Column B are unchanged. I envision the ...
user avatar
1 vote
1 answer
260 views

comparing binary files at different offsets, reporting offsets of first difference

[About a month ago I asked a similar question, requesting a specific CLI software tool that would perform the required task ; it was quickly blocked on the ground that asking for specific software ...
user avatar
  • 777
0 votes
1 answer
270 views

Comparing ISO image files in Windows 10 or MacOS

I have a number of CDs and DVDs (some RW and some not). Some of these disks contain simple files (such as .txt, .doc, etc) and others contain Dell system drivers, various Windows OS's and so on. I am ...
user avatar
0 votes
2 answers
532 views

Comparing two folders and copy differences in another folder

I want to compare Dir1 with Dir2 including subfolders for content ( the directory may contain binary data) If there are differences, I want to create a DiffDir which has the changed or added files ...
user avatar
0 votes
1 answer
35 views

Comparing Time (only) in two columns and returning value from the third column

I need to call the corresponding value of time from column F in column B. Tried using Vlookup and match/index functions. But they are not working for time. If you know a quick method please share.
user avatar
  • 1
0 votes
1 answer
47 views

Compare 2 text files and create a 3rd text file where rows are formatted with common strings (adjacent string completion) [closed]

I have 2 text files. text1.txt : First is structured in this way <title>Developing a wireless </title> ##www.google.com## <title>Webdriver Actionchains </title> ##www.alfa.com#...
user avatar
  • 67
2 votes
0 answers
297 views

How can I interactively diff large binary files?

I'm trying to compare hex-dumps of some 500GB disk images. I can easily view parts of the files by piping hd into less. I'd like something similar to interactively diff them without having to read the ...
user avatar
1 vote
2 answers
40 views

Seeing if a workbook contains data from another, and then adding the data if it doesn't?

Basically what title says, I have two separate workbooks with thousands of entries. One is an updated version of the other. I'm trying to find what's new in one workbook and add it to the older one.
user avatar
1 vote
1 answer
153 views

ExcelFuzzyLookUp: Compare Cells In The Same Row

I'm trying to compare two cells that are in the same row and same table. I've been trying to use Fuzzy Lookup to provide a measure of similarity but what happens is that the cells move to match what I'...
user avatar
4 votes
1 answer
5k views

Windows Batch Script to Compare Two Text Files

I have this script: for /f "delims=" %%a in (data_A.txt) DO ( set "flag=" for /f "delims=" %%b in (data_B.txt) do ( if "%%a"=="%%b" CALL :flagit ) if not defined flag >>...
user avatar
  • 399
1 vote
0 answers
24 views

Visual Studio comparing workspaces

First, let me explain the situation: I'm a software developer currently in home office. Normally we're using a TFS to sync our sources, but from home I don't have a connection to the TFS. So I'm ...
user avatar
0 votes
1 answer
42 views

Comparison Operator in Powershell

I have a script that is currently working. There are two groups that need to be omitted from the CSV that is exported. As it currently sits it works. see below: Import-Csv -Path .\importactiveusers....
user avatar
0 votes
2 answers
67 views

Compare 2 Lists of E-mail Addresses

How can I go about performing a comparison between 2 lists of e-mail addresses? Specifically, I am looking to find what e-mail addresses are not present in one list vs the other.
user avatar
0 votes
1 answer
52 views

awk comparison on Ubuntu

I'm trying to write a script that check the disk usage of remote clients. There is a filter in script for meaningful output: ... ssh server "sudo df -Ph 2>/dev/null \ | tail -n +2 \ | grep -v ...
user avatar
0 votes
1 answer
5k views

Compare Two Files and Remove the Duplicates

What is the easiest way to compare 2 files and deleting the duplicates found on both files. I'm aware you can do this easily on a linux box with certain commands, but how would I go about achieving ...
user avatar
1 vote
1 answer
134 views

Microsoft Word: how to compare and edit 2 documents, without creating a 3rd one

I do proof reading on documents written by non-native English speakers. With text editors you get to compare 2 versions of the same document and you can edit either directly. In Microsoft Word, ...
user avatar
  • 133
1 vote
0 answers
22 views

Merge two incomplete backup volumes together on a third drive?

I have 2 drives that use to be backed up to each other (a 2TB drive to a 3TB drive) but they fell out of sync a long time ago. Files on the drives may not be located in the folders they use to share, ...
user avatar
0 votes
2 answers
849 views

Excel: Column comparison with dates and values

I currently have 4 columns that contain data on Bitcoin Prices and S&P 500 closing day values, as well as their respective dates: Since the S&P 500 is closed on non-trading days and the ...
user avatar
-3 votes
2 answers
146 views

Why is there a loss in processor power emulating 32bit programs on a 64bit system?

May be a stupid question but I cannot find a clear answer. Host CPU=Emulated CPU Pentium Pro 200 MHz = 286 6 MHz Pentium II 350 MHz = 386SX 25 MHz Pentium III 1.0 GHz = 486 66 MHz Pentium ...
user avatar
  • 1
-1 votes
1 answer
134 views

Excel - Need to compare two times in order

I am using excel to compare two date columns that i need to compare. One is an Expiry time (SLA Expiry Time) and the other one is when it was actually updated (Initial SLA Contact Time). It is to ...
user avatar
  • 101
3 votes
1 answer
2k views

Compare two binary files of different sizes

I am trying to compare two binary files in order to identify one of them. The first file I have contains the data I am interested in and can use to identify the second. The second file is from a 3rd ...
user avatar
2 votes
0 answers
971 views

mac tmutil compare works or fails depending on WHERE bundle is mounted

Using Time Machine to a Time Capsule - backups work smoothly. The problem is trying to use 'tmutil compare' to see the differences between 2 backups. MacOS Mojave 10.14.5 (same problem on previous OS ...
user avatar
  • 21
1 vote
0 answers
952 views

Microsoft Excel Fuzzy Lookup add-on - set too big?

The data I'm comparing is a set of cataloged items (90k items) with an old list of items we thought were missing (about 11k). I need to see if any of the "missing" items actually show up in the ...
user avatar
0 votes
0 answers
333 views

Compare two whole HDD's contents, sector-level

While analysing two 4TB HDDs, which were in some kind of RAID 1 configuration, and thus have the same contents in terms of files / folders (they have been reformatted but R-Studio lists the same file ...
user avatar
  • 777
1 vote
0 answers
59 views

Redgate SQL Data Compare - Command LIne Output File

I am comparing 2 databases via command line. When I execute the following command: SQLDataCompare /project:"C:\CompareFiles\compare_AW1_AW2.sdc" /Include:table:[Users] /Out:"C:\Users\mthurman\...
user avatar
2 votes
1 answer
84 views

Compare and partly merge multiple projects without common ancestor

I'm looking for a way to compare/diff 3+ different, strongly related projects, none of which is the others' common ancestor and copy around ("merge") single chunks, and specifically test files. I do ...
user avatar
  • 23
0 votes
1 answer
598 views

How to compare multiple PDF files?

My professor just uploaded an updated set of all the slides of the whole semester (17 PDFs), referring to them as the now definite examination material. Problem is, I have made lots of notes on the ...
user avatar
0 votes
1 answer
51 views

Match 2 sets of numbers in 2 cells

I have 2 cells with similar data extracted from 2 different websites. Data in D6 is supposedly shorter version of H6. I want to put "Match" or "No Match" in E6. For "Match" either 2 sets of numbers ...
user avatar
0 votes
2 answers
4k views

Excel check if combination of data exists in a certain range

See question 1337631 Check if a specific range of values in one dataset exists in another dataset This solution works great, but what if you want to check WITHIN the same range? Want to use this for ...
user avatar
1 vote
1 answer
69 views

Compare excel worksheets

Here is the problem I have been trying to resolve all morning - I have two Excel worksheet files: Subset: This file has a subset of employees with various details including training status such as in-...
user avatar
  • 11
0 votes
1 answer
56 views

Determine Multiple values exist in column for same values in other column

I am hoping someone can help me with a formula for the following: Excel hard data My goal is to have an addition column return a yes or a no. Yes if there are different values in column B for the same ...
user avatar
  • 3
1 vote
2 answers
6k views

Compare three or more Word documents (*.docx)

I've seen multiple questions and answers for how to compare two Word documents, and I've seen some questions and answers for how to compare three or more raw text files, but I'm struggling to find a ...
user avatar
  • 311
1 vote
0 answers
1k views

Compare two folders on the basis of file names only

First , let me explain my situation , I have been scraping images from a website to a local folder, I used OpenCV to apply pre-processing on said images and produced the processed images with exactly ...
user avatar
  • 111
-2 votes
1 answer
135 views

How do the "games-oriented" NVIDIA-GPU-based cards behave w.r.t. CUDA computation?

NVIDIA makes GPUs, which are used both for graphics and for graphics-unrelated computing. It also publishes compute-related specs of its GPUs. Now, when it comes to cards: there are some cards that ...
user avatar
  • 7,312
0 votes
1 answer
904 views

HLS vs HTTP format codes in youtube-dl

I am using youtube-dl on windows 10 64 bit. I am new to this program. I checked the available formats for a video from dailymotion like this: youtube-dl -F "http://www.dailymotion.com/video/". In the ...
user avatar
1 vote
2 answers
727 views

Compare binary files with different meta data

In Windows, I wish to compare old binary files with newly built ones in order to determine which files has been updated. However, when I build the files I give them new meta data details (like version ...
user avatar
1 vote
2 answers
2k views

Check if a specific range of values in one dataset exists in another dataset

I have two datasets, 1 and 2, each containing a number of columns with values. My end goal is to find all of the rows in dataset 1 that are different from and can't be found in dataset 2. Dataset 1 (...
user avatar
1 vote
0 answers
2k views

Is there a way to compare two web pages or tabs in Chrome?

I have a website that offers me a "preview" mode, and a "live" mode of a document. I can open each in their own tab in Chrome. I'd like to know if there is a way to compare the two in Chrome, perhaps ...
user avatar
1 vote
3 answers
113 views

Cross compare data between 2 workbooks

I'm trying to cross compare 2 data in 2 different workbook. Then, I need to find the missing data between the 2 and make a separate new, updated list. However, I only need to update the data if there'...
user avatar

1
2 3 4 5 6