Sponsored Content
Full Discussion: matching columns
Top Forums UNIX for Dummies Questions & Answers matching columns Post 302594706 by Gery on Wednesday 1st of February 2012 04:15:56 AM
Old 02-01-2012
matching columns

Hello experts,

I have this problem, I need to match values based on two files, this is what I have:

file1
Code:
1.1
1.2
1.3
5.5
1.4
1.5
1.6

file2
Code:
1 a
2 B
3 C
4 D
5 z
6 F
7 G
8 H
9 I
10 J
11 K
12 L
13 M
14 N
15 O
16 P
17 Q
18 R
19 S
20 T

and the desired output is:

Code:
a
a
a
z
a
a
a

I'm using this code:

Code:
awk 'NR==FNR{a[int($1+.5)];next} $1 in a {print $2}' file1 file2

but I just get this:

Code:
a
z

this is Smilie

how could I modify the code above to get what I want? any help is very grateful,

Thanks in advance
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

matching columns with overlapping value ranges

Hi, I want to match and print columns that match. So my file looks like this: h1 20 30 h1 25 27 h2 50 70 h2 90 95 h2 60 80 h2 70 75 h3 130 150 h3 177 190 h4 140 190 h4 300 305 So there are 6 columns. Column 1 and 4 are names. I am able to get the... (2 Replies)
Discussion started by: kylle345
2 Replies

2. Shell Programming and Scripting

matching columns from two files

Hey, I have two files that have exactly the same format. They are both tab-delimited and contain 12 columns. However the # of rows vary. What I want to do is match columns # 5,6 and 7 between the two files. If they do match exactly (based on numbers) then I want the whole row from file 2 to... (1 Reply)
Discussion started by: phil_heath
1 Replies

3. UNIX for Dummies Questions & Answers

Matching corresponding columns in two different files

Hi to all, I have two separated files: FILE1 "V1" "V2" "V3" Mary James Nicole Robert Francisco Sophie Nancy Antony Matt Josephine Louise Rose Mark Simon Charles FILE2 "V1" "V2" "V3"... (2 Replies)
Discussion started by: eleonoral
2 Replies

4. Shell Programming and Scripting

Clustering data by matching columns

I am stuck with by DNA clustering analysis. I thought this forum will be a great help with data manipulations. Please help me. I have a table with 91 columns. First I want to trim the table to only having rows where the column values are single characters which are A,T,G,C or 0. So any row... (4 Replies)
Discussion started by: geetu
4 Replies

5. Shell Programming and Scripting

Help with awk Matching columns from two files

Hello, I have two files as following: #bin chrom chromStart chromEnd name score strand observed 585 chr2 29442 29443 rs4637157 0 + C/T 585 chr2 33011 33012 rs13423995 0 + A/G 585 chr2 34502 34503 rs13386087 0 + ... (2 Replies)
Discussion started by: Homa
2 Replies

6. Shell Programming and Scripting

Join two files with matching columns

Hi, I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it. Basically my data looks like this, with the TICKER columns matching up in each file File1 TICKER,column 1, column, 2, column, 3, column 4 ... (6 Replies)
Discussion started by: unkleruckus
6 Replies

7. Shell Programming and Scripting

Returning specific columns upon matching

Hi All, Need help in this requirement. I have fileA with one column and fileB with 26 columns. I need to match the value from fileA with fileB, if matches I have to return that value from fileB, and the next value, 5th and 6th values. NOTE- the matching value's position changes in... (7 Replies)
Discussion started by: vamsikrishna928
7 Replies

8. Shell Programming and Scripting

Matching first 2 columns..

Hello All, I want to make a file which will have primarily lines of file2 but when first 2 fields matches with the file1 it should have those lines of file1.. example is as below.. file1 a;b;1 c;d f;e t;r;5 file2 b;g a;b c;d v;b f;e t;r (2 Replies)
Discussion started by: ailnilanjan
2 Replies

9. Shell Programming and Scripting

Joining Two Files Matching Two Columns

Hi All, I am looking to join two files where column 1 of file A matches with column 1 of file B and column 5 of files A matches with column 2 of file B. After joining the files based on above condition, out should contain entire line of file A and column 3, 4 and 5 of file B. Here is sample... (8 Replies)
Discussion started by: angshuman
8 Replies

10. Shell Programming and Scripting

awk Matching Columns - Am I missing something?

I am using awk to match columns and output based on those matches. For some reason it is not printing matching columns, am I missing something? Operating system - windows with cygwin. Command that I am using: sed 's/]*,]*/,/g' $tempdir/file1 > $tempdir/file1.$$ && awk -F, 'FNR==NR{f2=$2... (7 Replies)
Discussion started by: dis0wned
7 Replies
PARTY(1)						      General Commands Manual							  PARTY(1)

NAME
party - set OS responses mode SYNOPSIS
party ON|OFF|WHEREIS [ - ] dnv DESCRIPTION
Operating systems being what they are, the admin people can easily grow tired of command responses that resemble dyslexic eugene- speak filtered through Kernighan and Ritchie's collective back-brains. To alleviate this, we have included a slightly more `casual' mode, in which the responses to all commands are first filtered through a customising routine (DUDE) , which makes them sound a little more friendly while retaining their full information content (usually). The rooted(c) system prompt is changed to `What now, dude?' and output from each command is terminated by `No problem, dude.' OPTIONS
-v Verbose mode (ALL commands have a `verbose' mode). When this option is present, all filtered responses are preceeded by a message: `This response has been parsed by the DUDE filter and is not intended to be some sort of sleazy come-on.' -d Don't restart all processes after recompiling the /uselss/libs/eugene file (see below). This alows any important tasks to complete beforehand. -n Notify all users that they are about to be force-logged out and force-logged in again. ON Activates the DUDE filter. OFF De-activates the DUDE filter. WHEREIS Doesn't do anything, but we couldn't resist it. EXAMPLES
%-) party on What now, dude? To compare the differing responses, here is output provided by the ispi -s command, with party OFF and party ON: party OFF line who why how long ========================================================== 000 rooted that's you, dweeb! epoch ---------------------------------------------------------- 00F wp she's supposed to be 0:44:12 typing up the end of financial year report, but she's been doing her resume when she thinks no-one is watching ---------------------------------------------------------- 014 maint playing games, as usual 0:51:16 party ON Well, let's see who's on, eh? There's you, of course, on line 000 (Imagine that! Hahaha!) Oh look, on serIOus line 00F, it's that cute little secretary - looks like she's lost her keyboard template again, she's been hitting the escape key for the past five minutes! AND OF COURSE, the guys down in maintenance are playing `cosmic ballcrushers'. As usual. Well, who else, um, no-one really interesting like, ya know, oh hang on, DTR is toggling on serIOus line 03D.. oh, no problem, it's that stuffed modem again. You want maybe I should send some AMail to maintenance and get 'em to look at it? No problem, dude. What now, dude? FILES
/uselss/libs/bill&ted/DUDE This is the pipe process, usually started at system shoe, which lies idle until party ON is issued. /uselss/libs/eugene Contains all of the ordinary, ho-hum confusing computer - jargonese responses which commands ordinarily issue. Text file. /uselss/libs/eugene.spoo compiled version of the eugene file. /ephemeral/eugene.chex Checksum for the compiled eugene file. SEE ALSO
crp(1), stuffio(2), doobrie(9), gouge(3), ftang(65534), wi(-1), edmond(29), jumpstart(2), vo_mit(992) BUGS
The -n option can be slow. If the n option is issued, some users in a wi editing session may not receive the `warning, restart imminent' message until after the restart. There is no way selectively to follow symbolic links. Sunburne Computer, Inc. 9 October 1991 Aug 18, 1997 PARTY(1)
All times are GMT -4. The time now is 01:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy