Sponsored Content
Full Discussion: Match and Merge two file
Top Forums UNIX for Beginners Questions & Answers Match and Merge two file Post 302997305 by AbelLuis on Wednesday 10th of May 2017 11:29:18 PM
Old 05-11-2017
Quote:
Originally Posted by Don Cragun
Not quite. That does not give the output requested in post #1; the merge option to sort does not remove duplicates.
Yes, I agree. The command must be

Code:
sort -mu file1 file2 > combined_file

I wonder if always is it the same that

Code:
sort -u file1 file2 > combined_file

Regards.

Post Data:

Perhaps the difference lies in performance. While sort -mu only combines the files already ordered, sort -u reorders the union of all, so which it does extra work.

Last edited by AbelLuis; 05-11-2017 at 12:46 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to find first match and last match in a file

Hi All, I have a below file: ================== 02:53 pravin-root 02:53 pravin-root 03:05 pravin-root 02:55 pravin1-root 02:59 pravin1-root ================== How do I find the first and last value of column 1. For example, how do I find 02:53 is the first time stamp and 03:05 is... (3 Replies)
Discussion started by: praving5
3 Replies

2. Shell Programming and Scripting

Merge two file data together based on specific pattern match

My input: File_1: 2000_t g1110.b1 abb.1 2001_t g1111.b1 abb.2 abb.2 g1112.b1 abb.3 2002_t . . File_2: 2000_t Ali england 135 abb.1 Zoe british 150 2001_t Ali england 305 g1111.b1 Lucy russia 126 (6 Replies)
Discussion started by: patrick87
6 Replies

3. Shell Programming and Scripting

Match on first and last columns and merge

Hi Friends, I have an input file of this kind input.txt output.txt The logic is as follows, read a row, compare column1 to the next, if there is a match, compare column4. If these two match, grab the minimum of column2 and maximum of column3 and print the output with column1,... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

4. Shell Programming and Scripting

AWK to match and merge data from 2 files into 1.

Hello, hopefully this is an easy on for the AWK guru's out there. I'm having some trouble figuring out how to match+merge data in 2 files into 1 single report. I've got my 2 files filtered and delimited, just need to MATCH $3 in file1 to $1 in file2, then put $0 from File1 and $2+$3 from File2... (6 Replies)
Discussion started by: right_coaster
6 Replies

5. Shell Programming and Scripting

Match pattern1 in file, match pattern2, substitute value1 in line

not getting anywhere with this an xml file contains multiple clients set up with same tags, different values. I need to parse the file for client foo, and change the value of tag "64bit" from false to true. cat clients.xml <Client type"FIX"> <ClientName>foo</ClientName>... (3 Replies)
Discussion started by: jack.bauer
3 Replies

6. Shell Programming and Scripting

awk match and merge with 2 files

Dear Awk experts! I have been trying to get a one liner for a match and merge operation, but having difficulties as I'm an awk newb. I always get stuck on the match and merge with 2 files. I have 2 files as follows: File 1: field 1,field 2,field 3,field 4,field 5,field 6,field 7,field... (6 Replies)
Discussion started by: landossa
6 Replies

7. UNIX for Dummies Questions & Answers

Merge rows into one if first 2 columns match

Hi, I wanted to merge the content and below is input and required output info. Input: /hello,a,r /hello,a,L /hello,a,X /hi,b,v /hi,b,c O/p: /hello,a,r:L:X /hi,v,:v:c Use code tags, thanks. (6 Replies)
Discussion started by: ankitas
6 Replies

8. Shell Programming and Scripting

Merge lines based on match

I am trying to merge two lines to one based on some matching condition. The file is as follows: Matches filter: 'request ', timestamp, <HTTPFlow request=<GET: Matches filter: 'request ', timestamp, <HTTPFlow request=<GET: Matches filter: 'request ', timestamp, <HTTPFlow ... (8 Replies)
Discussion started by: jamie_123
8 Replies

9. Shell Programming and Scripting

Display match or no match and write a text file to a directory

The below bash connects to a site, downloads a file, searches that file based of user input - could be multiple (all that seems to work). What I am not able to figure out is how to display on the screen match found or no match found" and write a file to a directory (C:\Users\cmccabe\Desktop\wget)... (4 Replies)
Discussion started by: cmccabe
4 Replies

10. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies
TAGGREPPER(1)							   User Commands						     TAGGREPPER(1)

NAME
taggrepper - search and match tags of media file for regular expressions SYNOPSIS
taggrepper [--tag-label regexp]... [--display-taglabel]... [FILE/DIRECTORY]... DESCRIPTION
Perform a regular expression search on the tags of specified media files. Mandatory arguments to long options are mandatory for short options too. All regular expressions are Perl Compatible Regular expressions supported by the PCRE libraries. Note that all matches are ANDed, meaning that for a successful match, matches against all tags must occur. Support exists for MP3 files, and, if compiled in, for Ogg Vorbis and FLAC files as well. -t, --title=REGEXP Match the title tag against REGEXP -a, --artist=REGEXP Match the artist tag against REGEXP -l, --album=REGEXP Match the album, tag against REGEXP -y, --year=REGEXP Match the year tag against REGEXP -g, --genre=REGEXP Match the genre tag against REGEXP -c, --comment=REGEXP Match the comment tag against REGEXP --track=REGEXP Match the track tag against REGEXP -c, --composer=REGEXP Match the composer tag against REGEXP -o, --orig-artist=REGEXP Match the original artist tag against REGEXP -c, --copyright=REGEXP Match the copyright tag against REGEXP -u, --url=REGEXP Match the URL tag against REGEXP -e, --encoded-by=REGEXP Match the encoded-by tag against REGEXP --any-tag=REGEXP Match the encoded-by tag against REGEXP. Using this option makes every one of the above options to be ignored --display-title display title tag of matching files --display-artist display artist tag of matching files --display-album display album tag of matching files --display-year display year tag of matching files --display-genre display genre tag of matching files --display-comment display comment tag of matching files --display-track display track tag of matching files --display-composer display composer tag of matching files --display-orig-artist display orig-artist tag of matching files --display-copyright display copyright tag of matching files --display-url display url tag of matching files --display-encoded-by display encoded-by tag of matching files -0, --print0, Use null character as delimiter. This option can be used with -0 option of xargs. -r, --recursive Search directories recursively -v, --version Display version and exit -h, --help Display this help message All regular expressions are PCRE regular expressions. Refer to the PCRE documentation for details. Report comments and bugs to a.kumar@alumni.iitm.ac.in COPYING
Copyright (C) Kumar Appaiah License: BSD License (see COPYING file in the distribution tarball for details) This program is free software; you can distribute it under the terms of the BSD License. See the file COPYING in the tarball, or /usr/share/common-licenses/BSD on Debian-based systems. SEE ALSO
pcre(3) taggrepper 0.01 July 2009 TAGGREPPER(1)
All times are GMT -4. The time now is 04:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy