Sponsored Content
Full Discussion: Help with file comparison
Top Forums Shell Programming and Scripting Help with file comparison Post 302565762 by vgersh99 on Tuesday 18th of October 2011 04:26:55 PM
Old 10-18-2011
Quote:
Originally Posted by cartrider
vgersh99,
It still does not return line starting with 0010 which is a new line. Output should exclude line 0002 as this is a change line not a new line.
Code:
/home/aa>nawk 'FNR==NR{f1[$0];next} !($0 in f1)' old.txt new.txt
0002    732     AC
0003    801     A
0006    908     Z
0011    512     X
0012    732     Z

What's the key? The first field in both files?
Code:
nawk 'FNR==NR{f1[$1];next} !($1 in f1)' old.txt new.txt

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

File Comparison

I have to compare two text files, very few of the lines in these files will have some difference in some column. The files size is in GB. Sample lines are as below: 11111122222222333333aaaaaaaaaabbbbbbbbbccccccccdddddd 11111122222222333333aaaaaaaaaabbbbbbbbbccccccccddeddd So assuming these... (19 Replies)
Discussion started by: net_shree
19 Replies

2. UNIX for Dummies Questions & Answers

file comparison...help needed.

Hello all, Can anyone help me with this. There are two files and I have to match the second file records with that of first and if matched, print the output in two fies, one containing the matched records and other containing the rest. Here is the example. File1 "111",erter,"00000", ... (4 Replies)
Discussion started by: er_ashu
4 Replies

3. Shell Programming and Scripting

file comparison

hi I have 2 files to comapre ,in file a sible column it is numbers,in file b2 numbers and other values with coma separated. i want compare numbers in file a with file b,and the out put put should be in C with numbers in both file a and b along with other columns of file b. i used folowing... (7 Replies)
Discussion started by: satish.res
7 Replies

4. Shell Programming and Scripting

File Comparison- Need help

I have two text files which have records of thousand rows. Each row is having around 40 columns. Each column is tab delimited. Each row is delimited by newline character. My requirement is to find for each row i need to find whether any column is different between the two files. For each row i... (8 Replies)
Discussion started by: uihnybgte
8 Replies

5. Shell Programming and Scripting

File Comparison

Hi i have 2 csv files a.csv and b.csv with the same number of columns and a list of values in both of it. Each and every individual value in both the files need to compared and if it matches then print correct in a new csv file otherwise print Incorrect eg a.csv 1,12/27/2007,Reward,$10.00... (5 Replies)
Discussion started by: naveenn08
5 Replies

6. Shell Programming and Scripting

two file comparison

now i have a different file zoo.txt with content 123|zoo 234|natan 456|don and file rick.txt with contents 123|dog|pie|pep 123|tail|see|newt 456|som|sin|sim 234|pay|rat|cat i want to look for lines in file zoo.txt column1 that has same corresponding lines in column 1 of... (6 Replies)
Discussion started by: dealerso
6 Replies

7. Shell Programming and Scripting

CSV file comparison

Hi all, i have two .csv files. i need to compare those two files and if there is any difference that should be moved into third .csv file. example, org.csv and dup.csv when we compare those two files org.csv and dup.csv. if there is any change in dup.csv. it should be capture in third... (7 Replies)
Discussion started by: baskivs
7 Replies

8. Shell Programming and Scripting

file comparison

Dear All, I would really appreciate if you can help me to resolve this file comparison I have two files: file1: chr start end ID gene_name chr1 2020 3030 1 test1 chr1 900 5000 2 test1 chr2 5000 8000 3 test2 chr3 6000 12000 4 test3 chr3 6000 15000 5 test3 file2:... (2 Replies)
Discussion started by: paolo.kunder
2 Replies

9. Shell Programming and Scripting

File Comparison: Print Lines not present in another file

Hi, I have fileA.txt like this. B01B02 D0011718 B01B03 D0012540 B01B04 D0006145 B01B05 D0004815 B01B06 D0012069 B01B07 D0004064 B01B08 D0011988 B01B09 D0012071 B01B10 D0005596 B01B11 D0011351 B01B12 D0004814 B01C01 D0011804 I want to compare this against another file (fileB.txt)... (3 Replies)
Discussion started by: genehunter
3 Replies

10. Shell Programming and Scripting

File Comparison

HI, I have two files and contains many Fields with | (pipe) delimitor, wanted to compare both the files and get only unmatched perticular fields. this i wanted to use in shell scriting. ex: first.txt 111 |abc| 230| hbc231 |bbb |210 |bbd405 |ghc |555 |cgv second.txt 111 |abc |230 |hbc231... (1 Reply)
Discussion started by: prawinmca
1 Replies
sdiff(1)							   User Commands							  sdiff(1)

NAME
sdiff - print differences between two files side-by-side SYNOPSIS
sdiff [-l] [-s] [-o output] [-w n] filename1 filename2 DESCRIPTION
sdiff uses the output of the diff command to produce a side-by-side listing of two files indicating lines that are different. Lines of the two files are printed with a blank gutter between them if the lines are identical, a < in the gutter if the line appears only in filename1, a > in the gutter if the line appears only in filename2, and a | for lines that are different. (See the EXAMPLES section below.) OPTIONS
-l Print only the left side of any lines that are identical.to -s Do not print identical lines. -o output Use the argument output as the name of a third file that is created as a user-controlled merge of filename1 and filename2. Identical lines of filename1 and filename2 are copied to output. Sets of differences, as produced by diff, are printed; where a set of differences share a common gutter character. After printing each set of differences, sdiff prompts the user with a % and waits for one of the following user-typed commands: l Append the left column to the output file. r Append the right column to the output file. s Turn on silent mode; do not print identical lines. v Turn off silent mode. e l Call the editor with the left column. e r Call the editor with the right column. e b Call the editor with the concatenation of left and right. e Call the editor with a zero length file. q Exit from the program. On exit from the editor, the resulting file is concatenated to the end of the output file. -w n Use the argument n as the width of the output line. The default line length is 130 characters. USAGE
See largefile(5) for the description of the behavior of sdiff when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes). EXAMPLES
Example 1 An example of the sdiff command. A sample output of sdiff follows. x | y a a b < c < d d > c ENVIRONMENT VARIABLES
If any of the LC_* variables ( LC_CTYPE, LC_MESSAGES, LC_TIME, LC_COLLATE, LC_NUMERIC, and LC_MONETARY ) (see environ(5)) are not set in the environment, the operational behavior of sdiff for each corresponding locale category is determined by the value of the LANG environ- ment variable. If LC_ALL is set, its contents are used to override both the LANG and the other LC_* variables. If none of the above vari- ables is set in the environment, the "C" locale determines how sdiff behaves. LC_CTYPE Determines how sdiff handles characters. When LC_CTYPE is set to a valid value, sdiff can display and handle text and file- names containing valid characters for that locale. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------------------------------------+ |ATTRIBUTE TYPE ATTRIBUTE VALUE | |Availability SUNWesu | |CSI Enabled | +-----------------------------------------------------------+ SEE ALSO
diff(1), ed(1), attributes(5), environ(5), largefile(5) SunOS 5.11 20 Dec 1996 sdiff(1)
All times are GMT -4. The time now is 04:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy