Sponsored Content
Top Forums Shell Programming and Scripting compare two files, selected columns only Post 302476070 by rdcwayx on Tuesday 30th of November 2010 06:41:34 PM
Old 11-30-2010
@ 丹

your code has a bug at a[$2$3], if $2 and $3 are (12 3456) and (123 456), awk will think they are same: a[123456]

Here is the fix.

Code:
$ cat file1
BCDG 124 542
FGD 459 762
ABS 13 2456

$ cat file2
ABS 132 456
FGD 459 762


awk 'NR==FNR{a[$2 FS $3]++;next}!a[$2 FS $3]' file1 file2

ABS 132 456


awk 'NR==FNR{a[$2 FS $3]++;next}!a[$2 FS $3]' file2 file1

BCDG 124 542
ABS 13 2456

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies

2. Shell Programming and Scripting

Compare EDI files by skipping selected Segments

Hi, I wanted to compare EDI files present in Two different Directories which can be related by the file names. While comparing the EDI files i have to skip selected segments such as "ISA" "IEA" and "GS" "GE" since this may have datetime stamp and different "Sender" "Receiver" Qual. and... (3 Replies)
Discussion started by: Sivas
3 Replies

3. Shell Programming and Scripting

Compare selected columns from a file and print difference

I have learned file comparison from my previous post here. Then, it is comparing the whole line. Now, i have a new problem. I have two files with 3 columns separated with a "|". What i want to do is to compare the second and third column of file 1, and the second and third column of file 2. And... (4 Replies)
Discussion started by: kingpeejay
4 Replies

4. Shell Programming and Scripting

How to compare 2 files & get only few columns based on a condition related to both files?

Hiiiii friends I have 2 files which contains huge data & few lines of it are as shown below File1: b.dat(which has 21 columns) SSR 1976 8 12 13 10 44.00 39.0700 70.7800 7.0 0 0.00 0 2.78 0.00 0.00 0 0.00 2.78 0 NULL ISC 1976 8 12 22 32 37.39 36.2942 70.7338... (6 Replies)
Discussion started by: reva
6 Replies

5. Shell Programming and Scripting

Compare selected columns of two files and print whole line with mismatch

hi! i researched about comparing two columns here and got an answer. but after examining my two files, i found out that the first columns of the two files are not unique with each other. all i want to compare is the 2nd and 3rd column. FILE 1: ABS 456 315 EBS 923 163 JYQ3 654 237 FILE 2:... (1 Reply)
Discussion started by: engr.jay
1 Replies

6. UNIX for Dummies Questions & Answers

Compare Columns in two files

Hi all, I would like to compare a column in one file to a column in another file and when there is a match it prints the first column and the corresponding second column. Example File1 ABA ABC ABE ABF File 2 ABA 123 ABB 124 ABD 125 ABC 126 So what I would like printed to a file... (0 Replies)
Discussion started by: pcg
0 Replies

7. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

8. UNIX for Dummies Questions & Answers

Help need to compare columns in files

Hi, Below is my requirement file1 id|cnt 1|1 2|2 3|3 file2 id_1|cnt_1 1|1 2|1 3|1 I want to compare cnt and cnt_1 columns, if they are differ then give the details Am using below awk command, but the output is not as expected. (2 Replies)
Discussion started by: grandhirahuletl
2 Replies

9. UNIX for Dummies Questions & Answers

How to compare two columns in two files?

Hi All, I have a.dat file with content 1,338,30253395122015103,2015103,UB0085000,STMT151117055527002,,, 1,338,30253395122015103,2015103,UB0085000,STMT151117055527001,,, and b.dat having content 1,STMT151117055527001,a1.txt,b1.txt,c1.txt 1,STMT151117055527002,a2.txt,b2.txt,c2.txt ... (13 Replies)
Discussion started by: PRAMOD 96
13 Replies

10. Shell Programming and Scripting

Match value in two files and replace values in selected columns

The purpose is to check if values for column 3 and 4 in file1 match with column 1 in file2. If any value match do: 1) Replace values in file2 for column 2 and 3 using the information of file1 columns 5 and 6 2) Replace string ($1,1,5) and string ($1,6,5) in file2 with values of columns 7... (8 Replies)
Discussion started by: jiam912
8 Replies
XSYSTEM35(6)						       xsystem35 User Manual						      XSYSTEM35(6)

NAME
xsystem35 - program to play System 3.5 games SYNOPSIS
xsystem35 [OPTIONS] DESCRIPTION
This manual page documents briefly the xsystem35 command. This manual page was written for the Debian distribution because the original program does not have a manual page. xsystem35 is a program to run System 3.5 games. Known games are: o Kichikuou Rance o Ikenai Katsumi Sensei o Rance IV for WIN o Tshin Toshi 2 for WIN o Kaerunyo Panyon o Ikusamiko o Ningengari (in Alice no Yakata 456) o Type Zero (in Alice no Yakata 456) o ATLACH=NACHA (in Alice no Yakata 456) o DALK (in Alice no Yakata 456) o Tshin Toshi (in Alice no Yakata 456) o Dr. Stop! (in Alice no Yakata 456) o Rance I (in Alice no Yakata 456) o Rance II (in Alice no Yakata 456) o Rance III (in Alice no Yakata 456) o o DiaboLiQuE o AmbivalenZ for Win95 o Pastel Chime o Prostudent GOOD o Mamorigami-sama o Mamatoto o Hushaby Baby o DARCROWS o Persiom o o SeeIN Ao o D.P.S.? (in 20 seiki Alice) o (in 20 seiki Alice) o Only You - Re cross o Lv1.5 o Daiakuji (Not opening) o (Not opening) OPTIONS
The program start with the following options starting with one dash (`-'). A summary of options is included below. -gamefile file set game resouce file to 'file' -no-shm don't use MIT-SHM (use in another display) -devcd device set cdrom device name to 'device' -devmidi device set midi device name to 'device' -devdsp device set audio device name to 'device' /dev/dsp : oss type (device name) -O? select output audio device -Oo OSS mode -Os ALSA mode -Oe Enlightened Sound Daemon mode -O0 Disable Audio output -M? select output midi methods -Me External midi player -Mr Raw Midi device -Ms? Sequenceer device (?:devicenumber) -M0 Disable MIDI output -midiplayer cmd set external midi player to 'cmd' -devmix device set mixer device name to 'device' (effective only for oss) -devjoy device set joystick device name to 'device' if 'device' is set to 'none', don't use the device -savekanji # kanji code of filename (0 or 1 ... 0:euc, 1:sjis) -antialias always draw antialiased string (for !256 colors game) -noantialias never use antialiased string (for !256 colors game) -fullscreen start with fullscreen -noimagecursor disable image cursor -version Show version of program. -h, --help Show summary of options. FILES
${HOME}/.xsys35rc The per-user configuration file to control the behaviour of xsystem35. AUTHOR
Ying-Chun Liu <paulliu@debian.org> Wrote this manpage for the Debian system. COPYRIGHT
Copyright (C) 2010 Ying-Chun Liu (PaulLiu) This manual page was written for the Debian system (and may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or (at your option) any later version published by the Free Software Foundation. On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL-2. xsystem35 11/20/2011 XSYSTEM35(6)
All times are GMT -4. The time now is 09:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy