Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find the difference in specific field
Top Forums Shell Programming and Scripting Find the difference in specific field Post 302970205 by znesotomayor on Sunday 3rd of April 2016 10:15:49 PM
Old 04-03-2016
Find the difference in specific field
Hi All,

Seeking for your assistance to get the difference of field1 and field2 and output all the records if there's a difference. please see below scenario.

Code:
file1.txt
250|UPTREND FASHION DESIGN,CORP.|2016-04-04 09:36:13.991257
74|MAINSTREAM BUSINESS INC.|2016-04-04 09:36:13.991257
36|HOMEWORLD SHOPPING CORP.|2016-03-30 12:50:13.50646

file2.txt
250|UPTREND FASHION DESIGN,CORP.|2016-04-04 09:33:13.991257
74|MAINSTREAM BUSINESS INC.|2016-04-04 09:35:13.991257

Code:
 I tried this diff file1.txt file2.txt | grep "<" | awk '{for (i=2; i<NF; i++) printf $i " "; print $NF}' but the problem is it will check all the records, all i want is the field1 and field2 check only.

Please advise,

Thanks,

---------- Post updated at 10:15 AM ---------- Previous update was at 09:56 AM ----------

I already solve the problem using this code
Code:
awk 'NR==FNR {exclude[$1$2];next} !($1$2 in exclude)' file2.txt file1.txt

Thank you!
Last edited by znesotomayor; 04-03-2016 at 11:03 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies

2. Shell Programming and Scripting

Find and replace a string a specific value in specific location in AIX

Hi, I have following samp.txt file in unix. samp.txt 01Roy2D3M000000 02Rad2D3M222222 . . . . 10Mik0A2M343443 Desired Output 01Roy2A3M000000 02Rad2A3M222222 . . (5 Replies)
Discussion started by: techmoris
5 Replies

3. Shell Programming and Scripting

Using awk to read a specific line and a specific field on that line.

Say the input was as follows: Brat 20 x 1000 32rf Pour 15 p 1621 05pr Dart 10 z 1111 22xx My program prompts for an input, what I want is to use the input to locate a specific field. Like if I type in, "Pou" then it would return "Pour" and just "Pour" I currently have this line but it is... (6 Replies)
Discussion started by: Bungkai
6 Replies

4. Shell Programming and Scripting

Compare two files and output difference, by first field using awk.

It seems like a common task, but I haven't been able to find the solution. vitallog.txt 1310,John,Hancock 13211,Steven,Mills 122,Jane,Doe 138,Thoms,Doe 1500,Micheal,May vitalinfo.txt 12122,Jane,Thomas 122,Janes,Does 123,Paul,Kite **OUTPUT** vitalfiltered.txt 12122,Jane,Thomas... (2 Replies)
Discussion started by: charles33
2 Replies

5. Shell Programming and Scripting

Replace specific field on specific line sed or awk

I'm trying to update a text file via sed/awk, after a lot of searching I still can't find a code snippet that I can get to work. Brief overview: I have user input a line to a variable, I then find a specific value in this line 10th field in this case. After asking for new input and doing some... (14 Replies)
Discussion started by: crownedzero
14 Replies

6. Shell Programming and Scripting

Can't figure out how to find specific characters in specific columns

I am trying to find a specific set of characters in a long file. I only want to find the characters in column 265 for 4 bytes. Is there a search for that? I tried cut but couldn't get it to work. Ex. I want to find '9999' in column 265 for 4 bytes. If it is in there, I want it to print... (12 Replies)
Discussion started by: Drenhead
12 Replies

7. Shell Programming and Scripting

Calculate the difference of two columns and keep the line with specific value

Hi everyone, I am trying to find sty all day. I have two files: File 1: N 82 AAA A 1 0.67 N 83 BBB B 1 0.79 N 84 CCC C 1 0.11 File 2: N 82 AAA A 1 0.63 N 83 BBB B 1 0.03 N 84 CCC C 1 0.08 I want to calculate... (2 Replies)
Discussion started by: Tzole
2 Replies

8. UNIX for Dummies Questions & Answers

Finding difference in 1st field for rows of data

I have a file that has multiple lines, of grouped data, that typically all have the same values in the 1st field, however, I would like to search the 1st field for any differences and set a flag to use in an "if" statement to run some other routine. An example of the typical file is below,... (2 Replies)
Discussion started by: co21ss
2 Replies

9. Shell Programming and Scripting

How to print with awk specific field different from specific character?

Hello, i need help with awk. I have this file: cat number DirB port 67 er_enc_out 0 er_bad_os 0 DirB port 71 er_enc_out 56 er_bad_os 0 DirB port 74 er_enc_out 0 er_bad_os 0 DirB port 75 ... (4 Replies)
Discussion started by: elilmal
4 Replies

10. UNIX for Beginners Questions & Answers

Find records with specific characters in 2 nd field

Hi , I have a requirement to read a file ( 5 fields , ~ delimited) and find the records which contain anything other than Alphabets, Numbers , comma ,space and dot . ie a-z and A-Z and 0-9 and . and " " and , in 2nd field. Once I do that i would want the result to have field1|<flag> flag can... (2 Replies)
Discussion started by: ashwin3086
2 Replies

LEARN ABOUT MINIX

pnmpsnr

pnmpsnr(1)                                                    General Commands Manual                                                   pnmpsnr(1)

NAME

       pnmpsnr - compute the difference between two portable anymaps

SYNOPSIS

       pnmpsnr [pnmfile1] [pnmfile2]

DESCRIPTION

       Reads  two  PBM,  PGM, or PPM files, or PAM equivalents, as input.  Prints the peak signal-to-noise ratio (PSNR) difference between the two
       images.  This metric is typically used in image compression papers to rate the distortion between original and decoded image.

       If the inputs are PBM or PGM, pnmpsnr prints the PSNR of the luminance only.  Otherwise, it prints the separate PSNRs of the luminance, and
       chrominance (Cb and Cr) components of the colors.

       The  PSNR  of  a  given component is the ratio of the mean square difference of the component for the two images to the maximum mean square
       difference that can exist betwee any two images.  It is expressed as a decibel value.

       The mean square difference of a component for two images is the mean square difference of the component value, comparing  each  pixel  with
       the pixel in the same position of the other image.  For the purposes of this computation, components are normalized to the scale [0..1].

       The maximum mean square difference is identically 1.

       So the higher the PSNR, the closer the images are.  A luminance PSNR of 20 means the mean square difference of the luminances of the pixels
       is 100 times less than the maximum possible difference, i.e. 0.01.

SEE ALSO

       pnm(5)

                                                                   04 March 2001                                                        pnmpsnr(1)
All times are GMT -4. The time now is 08:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy