Sponsored Content
Top Forums Shell Programming and Scripting AWK to compare two files for each field value Post 302334537 by Sangtha on Wednesday 15th of July 2009 11:01:27 PM
Old 07-16-2009
AWK to compare two files for each field value

I have "n" files in directory A and "n" files in directory B. The files are expected to be the same with same data. Each file has 14 columns and "x" rows. Of the 14 column, 2 columns are to be considered as key identifiers. Based on this unique combination, I need to compare each field value between the two files and report the difference.

Note: File in Directory A has values displayed upto 5 decimal places. But file in Directory B has some values displayed as scientific values, some whole numbers and some upto some decimal places.

I am a beginner with Bash and not sure on executing this.

Any help with code would be appreciated.

Thanks!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk conditional expression to compare field number and variable value

Hi, I'm trying to compare the value in a field to the value in a variable using awk. This works: awk '$7 == "101"'but this is what I want (and it doesn't work): value=101 awk '$7 == "$value"' Any help or insight on this would be great. Thanks in advance. (1 Reply)
Discussion started by: goodbenito
1 Replies

2. Shell Programming and Scripting

Compare Tab Separated Field with AWK to all and print lines of unique fields.

Hi. I have a tab separated file that has a couple nearly identical lines. When doing: sort file | uniq > file.new It passes through the nearly identical lines because, well, they still are unique. a) I want to look only at field x for uniqueness and if the content in field x is the... (1 Reply)
Discussion started by: rocket_dog
1 Replies

3. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 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. UNIX for Dummies Questions & Answers

compare two files based on common field in unix

I have two files in UNIX. 1st file is Entity and Second File is References. 1st File has only one column named Entity ID and 2nd file has two columns Entity ID | Person ID. I want to produce a output file where entity id's are matching in both the files. Entity File 624197 624252 624264... (4 Replies)
Discussion started by: PRS
4 Replies

6. Shell Programming and Scripting

Compare a common field in two files and append a column from File 1 in File2

Hi Friends, I am new to Shell Scripting and need your help in the below situation. - I have two files (File 1 and File 2) and the contents of the files are mentioned below. - "Application handle" is the common field in both the files. (NOTE :- PLEASE REFER TO THE ATTACHMENT "Compare files... (2 Replies)
Discussion started by: Santoshbn
2 Replies

7. Shell Programming and Scripting

Compare two files Field by field and output the result in another file

Hi Friends, Need Help. I have file1.txt as File1.txt |123|A|7267|Hyder|Cross|Sell|7801 |995|A|7051|2008|Lunar|New|Year|Promotion|7801 |996|A|7022|Q108|Targ|Prospect|&|SSCC|Savings|Promo|7801 |997|A|7182|Q1|Feb-Apr|08|Credit|ITA|PA|SBA|Campaign|7801 File2.txt... (7 Replies)
Discussion started by: i150371485
7 Replies

8. Shell Programming and Scripting

Plz Help. Compare 2 files field by field and get the output in another file.

Hi Freinds, I have 2 files . one is source.txt and second one is target.txt. I want to keep source.txt as baseline and compare target.txt. please find the data in 2 files and Expected output. Source.txt 1|HYD|NAG|TRA|34.5|1234 2|CHE|ESW|DES|36.5|134 3|BAN|MEH|TRA|33.5|234... (5 Replies)
Discussion started by: i150371485
5 Replies

9. Shell Programming and Scripting

awk to compare 2nd and 3rd field and print the differences

need a one liner to compare 2nd and 3rd field and print values that are not matched in 2nd field Input col 2 col 3 1.1.1.1 11.11.11.11 8.8.8.8 0.0.0.0 3.3.3.3 2.2.2.2 7.7.7.7 3.3.3.3 5.5.5.5 1.1.1.1 4.4.4.4 6.6.6.6 9.9.9.9 output 7.7.7.7 ... (12 Replies)
Discussion started by: chidori
12 Replies

10. Shell Programming and Scripting

Compare two CSV files and put the difference in third file with line no,field no and diff value.

I am having two csv files i need to compare these files and the output file should have the information of the differences at the field level. For Example, File 1: A,B,C,D,E,F 1,2,3,4,5,6 File 2: A,C,B,D,E,F 1,2,4,5,5,6 out put file: (12 Replies)
Discussion started by: karingulanagara
12 Replies
IFRIT(1)						      General Commands Manual							  IFRIT(1)

NAME
ifrit - a powerful tool that can be used to visualize 3-dimensional data sets SYNOPSIS
ifrit [qt-options] [options] [dir_name] DESCRIPTION
This manual page documents briefly the ifrit command. This manual page was written for the Debian distribution because the original pro- gram does not have a manual page. OPTIONS
-8 accepts an 8-bit display -d starts IFRIT with all windows docked together into a single window. -nf does not show the splash screen at start-up -sw uses small font to reduce the QT window size -rw IFRIT is being used remotely. This option can be used to minimize re-drawing of the widget windows. -ni IFRIT is not idiosyncratic. This prompts IFRIT not to ask for a confirmation when exiting or running scripts. -np number sets the number of processors to use. Note that only some parts of IFRIT support parallel execution so far. -i file_name loads the state from the previously saved state file filename. -b file_name runs IFRIT in batch mode, taking animation script from the file filename. If filename starts with sign "+", standard directories (see ENVIRONMENT VARIABLES ) will be prepended to the file name. -h -help show the list of available command-line options. ENVIRONMENT VARIABLES
IFRIT understands the following environment variables (all in capitals): IFRIT_DIR The main IFRIT directory where you keep the variable file ifrit.nam and options file(s) ifrit.ini. If this variable is not set, IFRIT assumes that current directory is the main directory. IFRIT_DATA_DIR: The default directory for the data files. If not set, IFRIT will start searching for the data files in the current directory. IFRIT_MESH_DATA_DIR The default directory for the mesh data files. If not set, IFRIT will start searching for the mesh data in the default data direc- tory. IFRIT_PART_DATA_DIR The default directory for the particle data files. If not set, IFRIT will start searching for the particle data in the default data directory. IFRIT_VECT_DATA_DIR The default directory for the vector field data files. If not set, IFRIT will start searching for the vector field data in the default data directory. IFRIT_TENS_DATA_DIR The default directory for the tensor field data files. If not set, IFRIT will start searching for the tensor field data in the default data directory. IFRIT_IMAGE_DIR The directory where IFRIT will place image and animation files. If not set, IFRIT will put image files into the current directory. IFRIT_SCRIPT_DIR The directory where IFRIT will place animation scripts. If not set, IFRIT will put scripts into its main directory. IFRIT_PALETTE_DIR The directory where IFRIT will place custom palettes. If not set, IFRIT will put palettes into its main directory. SEE ALSO
The IFRIT help system. AUTHOR
This manual page was adapted by Mark Hymers <mark.hymers@ncl.ac.uk> from the ifrit help system, for the Debian project (but may be used by others). September 09, 2004 IFRIT(1)
All times are GMT -4. The time now is 09:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy