Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Comparing two columns with two columns Post 302770701 by RudiC on Monday 18th of February 2013 04:17:31 AM
Old 02-18-2013
A bit easier to read (?):
Code:
$ awk 'NR==1; NR > 1 {$0=$0" "; print $0 gsub(" "$2" | "$3, "&") - 1 }' file
Item A B C D
1 201 3101 3101 201 2
2 3101 201 202 3101 1
3 3101 201 201 3102 1
4 3101 201 3201 202 0

 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Comparing Columns of two FIles

Dear all, I have two files in UNIX File1 and File2 as below: File1: 1,1234,.,67.897,,0 1,4134,.,87.97,,4 0,1564,.,97.8,,1 File2: 2,8798,.,67.897,,0 2,8879,.,77.97,,4 0,1564,.,97.8,,1 I want to do the following: (1) Make sure that both the files have equal number of columns and if... (1 Reply)
Discussion started by: ggopal
1 Replies

2. Shell Programming and Scripting

Comparing Columns of two FIles

Dear all, I have two files in UNIX File1 and File2 as below: File1: 1,1234,.,67.897,,0 1,4134,.,87.97,,4 0,1564,.,97.8,,1 File2: 2,8798,.,67.897,,0 2,8879,.,77.97,,4 0,1564,.,97.8,,1 I want to do the following: (1) Make sure that both the files have equal number of columns and if... (4 Replies)
Discussion started by: ggopal
4 Replies

3. Shell Programming and Scripting

comparing the columns in two files

I have two files file1 and file 2 both are having multiple coloumns.i want to select only two columns. i used following code to get the desired columns,with ',' as delimiter cut -d ',' -f 1,2 file1 | sort > file1.new cut -d ',' -f 1,2 file2 | sort > file2.new I want to get the coloums... (1 Reply)
Discussion started by: bab123
1 Replies

4. Shell Programming and Scripting

comparing 2 columns from 2 files

Hey, I have 2 files that have a name and then a number: File 1: dog 21 dog 24 cat 33 cat 27 dog 76 cat 65 File 2: dog 109 dog 248 cat 323 cat 207 cat 66 (2 Replies)
Discussion started by: dcfargo
2 Replies

5. UNIX for Dummies Questions & Answers

Comparing 2 columns from 2 files

Hi, I have two files with the same number of columns. Basically I want to print the 2 columns that match between the two files. File1 looks like this: dr12 12 6 abn dr14 12 7 abn File2 looks something like this: dr12 12 8 abn dr12 14 7 abn So basically if the first... (1 Reply)
Discussion started by: kylle345
1 Replies

6. Shell Programming and Scripting

Comparing two columns

Hi, I want to compare two columns and find out missing entries e:g Column 1 Column 2 1 1 2 2 3 13 4 10 19 234 Results woud be 13. I will appreciate very much if anyone help me :). (12 Replies)
Discussion started by: krabu
12 Replies

7. Shell Programming and Scripting

comparing two columns from two different files

Hello, I have two files as 1.txt and 2.txt with number as columns. 1.txt 0 53.7988 1 -30.0859 2 20.1632 3 14.2135 4 14.6366 5 -37.6258 . . . 31608 -8.57333 31609 -2.58554 31610 -24.2857 2.txt (1 Reply)
Discussion started by: AKD
1 Replies

8. Shell Programming and Scripting

Comparing rows and columns

Hi, i've a .csv file with the data as below: - file1.h, 2.0 file2.c, 3.1 file1.h, 2.5 file3.c, 3.3.3 file1.h, 1.2.3 I want to remove the duplicate file names considering only the one with the highest version number.. output should be file1.h, 2.5 file2.c, 3.1 file3.c,... (3 Replies)
Discussion started by: pravsripad
3 Replies

9. Shell Programming and Scripting

Comparing columns in a file

I have two files. One a small one and another one is big. The smaller one look like this: Filename: 1.tmp 3453 0 326543 1 2321 0 3212 1 The big file looks like this: Filename 1.res 0.3232 2321 9.2922 123 0.983 3212 8.373 326543 0.9 3453 1.098 3432 I want to extract those lines... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies

10. Shell Programming and Scripting

Comparing two columns from two different files

Hi, I have a single-column file1 having records like: 00AB01/11 43TG22/00 78RC09/34 ...... ...... and a second file , file 2 having two columns like 78RC09/34 1 45FD11/11 2 00AB01/11 3 43TG22/00 4 ...... ...... (8 Replies)
Discussion started by: amarn
8 Replies
books(3)							       Coin								  books(3)

NAME
books - Books Related to Open Inventor / Coin Here is a list of some of the better books for people that invested in software development with Open Inventor. If you have suggestions for additional books that ought to go on this list, please feel free to tell us about it. The Inventor Mentor (subtitle 'Programming Object-Oriented 3D Graphics with Open Inventor') This is an excellently written, detailed, tutorial-style introductory book for Open Inventor that takes you through all the fundamental design principles applied in the Open Inventor API, richly illustrated and with numerous, well documented code examples. The Inventor Mentor is getting a bit old, but do not let that put you off. It is as valid today as it was the day it was written, and we heartily recommend this book for anyone learning to use Open Inventor. ISBN 0-201-62495-8. You might also be able to find this book as a pdf file online, but we recommend having it in print. The Inventor Toolmaker This book explains how Open Inventor was designed for being extended by the users, and walks you through how to develop your own components that work with all aspects of Coin. ISBN 0-201-62493-1. You might also be able to find this book as a pdf file online, but we recommend having it in print. The Annotated VRML2.0 Reference Manual This book covers the VRML97 (aka VRML 2.0) standard, which Coin has implemented with its Inventor/VRMLnodes/* classes, which is an extension made beyond the Open Inventor V2.1 API. The VRML97 format has some significant differences from the Inventor and VRML1 formats, so it is a useful book if you want to use that part of Coin. ISBN 0-201-41974-2. You will find the specification documents for VRML97 online at http://www.web3d.org/. The Open GL Programming Manual This is the bible when it comes to OpenGL programming and is relevant for Open Inventor extenders that develop new nodes that implement or affect Open Inventor OpenGL rendering. There are many editions of this book since it is updated whenever new versions of OpenGL are standardized and comes out, so check that you have identified the latest edition if you order one. The Open Inventor C++ Reference Manual Although this book is directly relevant for Open Inventor, it does only cover the Open Inventor 2.1 API. This information is more or less also covered in the online doxygen doc for Coin, where you have it hyperlinked, and can also be generated offline from the Coin sources to have locally, so we do not think this book is very useful to have in print. We mention it anyway since it is an official documentation book for Open Inventor. ISBN 0-201-62491-5. Version 3.1.3 Wed May 23 2012 books(3)
All times are GMT -4. The time now is 03:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy