Join with awk Post: 302950005

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Join with awk Post 302950005 by radius on Monday 20th of July 2015 04:11:31 AM

07-20-2015

Registered User

Join with awk

I have file 1 (f1)

Code:

531902021342|610231416030043
531902021421|610231415853764
531902021460|610231406819593
531902021477|610231410151075
531902021481|610230208405255
531902021484|0
531902021557|610231407330625
531902021558|610230208106654
531902021564|610230204101407

file 2(f2)

Code:

610231416030043|USA 1
610230000021247|USA 1
610230000021375|USA 1
610230000021376|USA 1
610230000021377|USA 1
610230000021415|ENG 1
610230000021416|ENG 1
610230000021417|ENG 1
610230000021421|ENG 1

I need to join f2 (second column) to f1 when column 2 in f1 equals with column 1 in f2. Expected Output should be

Code:

531902021342|610231416030043|USA 1
531902021421|610231415853764|
531902021460|610231406819593|
531902021477|610231410151075|
531902021481|610230208405255|
531902021484|0|
531902021557|610231407330625|
531902021558|610230208106654|
531902021564|610230204101407|

I did this

Code:

awk 'NR==FNR {h[$2] = $1; next} {print $1,$2,$3,h[$2]}' f2 f1

but it doesnt work..please help

radius

View Public Profile for radius

Find all posts by radius

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk for join

Is it possible to do this with awk command?? sort1.txt a 10 b 20 sort2.txt a b c d join command join sort1.txt sort2.txt && join -v1 sort2.txt sort1.txt output a 10 b 20

2. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

Hello, My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns: File A: (tab-delimited) PDB CHAIN Start End Fragment 1avq A 171 176 awyfan 1avq A 172 177 wyfany 1c7k A 2 7...

3. Shell Programming and Scripting

Join using awk

Hi - I want to join 2 files on matching keys ( column 1 in both files ) and check for unmatched columns, If for each record print the first unmatched column from both files and then proceed to next record and do the same. File 1: 123|Roy|jj|20/07/3000|25.48 125|Victor|kk|30/07/2009|34.56...

4. Shell Programming and Scripting

how to join two files with awk.

Hi, Unix Gurus, I need to compare two file based on key value and load result to different files. requirement as following: file1 1, abc 2, bcd 4, cdefile2 1, aaaaa 2, bbbbb 5, ccccckey value is first column for both file. I need generate following files; records_in_1_not_2.txt 4,...

5. Shell Programming and Scripting

left join using awk

Hi guys, I need AWK to merge the following 2 files: file1 1 a 1 1 2 b 2 2 3 c 3 3 4 d 4 4 file2 a a/a c/c a/c c/c a/a c/t c c/t c/c a/t g/g c/c c/t desired output: 1 a 1 1 a/a c/c a/c c/c a/a c/t 2 b 2 2 x x x x x x 3 c 3 3 c/t c/c a/t g/g c/c c/t 4 d 4 4 x x x x x x

6. UNIX for Dummies Questions & Answers

Join or Awk

Is is possible to join on unsorted files by a string? Don't want to sort because there is other text that is already in a good format. I want to replace or join RBOSK-374 in file 2 with NB2781 FGH in file 1. Any help would be appreciated. a.log: RBOSK-374 AAA-B04-D16-K01 a.log: 0 XXX 602...

7. UNIX for Dummies Questions & Answers

Join with awk different column

hi guys, i need help I need to join file2 to file1 when column 3 in my file1 and column 1 in my file2 in the same string file1 AA|RR|ESKIM RE|DD|RED WE|WW|SUPSS file2 ESKIM|ES SUPSS|SS Output AA|RR|ESKIM|ES RE|DD|RED| WE|WW|SUPSS|SS

8. Shell Programming and Scripting

awk join 2 files

Hello All, file1 A1;B1;C1;D1;E1;F1;G1;H1;III1;J1 A2;B2;C2;D2;E2;F2;G2;H2;III2;J2 A3;B3;C3;D3;E3;F3;G3;H3;III3;J3 A4;B4;C4;D4;E4;F4;G4;H4;III4;J4file2 III1 ZZ1 S1 Y 1 P1 None NA III2 ZZ2 S2 Y 3 P2 None NA III3 ZZ3 S2 Y 5 ...

9. Shell Programming and Scripting

Join two files using awk

Hello All; I have two files: File1: abc def pqr File2: abc,123 mno,456 def,989 pqr,787 ghj,678

10. Shell Programming and Scripting

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

Hello, This post is already here but want to do this with another way Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: 1|123|jojo 1|NULL|bibi...

LEARN ABOUT REDHAT

tzselect

TZSELECT(8)						      System Manager's Manual						       TZSELECT(8)

NAME

       tzselect - select a time zone

SYNOPSIS

       tzselect

DESCRIPTION

       The  tzselect program asks the user for information about the current location, and outputs the resulting time zone description to standard
       output.	The output is suitable as a value for the TZ environment variable.

       All interaction with the user is done via standard input and standard error.

ENVIRONMENT VARIABLES

       AWK    Name of a Posix-compliant awk program (default: awk).

       TZDIR  Name of the directory containing time zone data files (default: /usr/local/etc/zoneinfo).

FILES

       TZDIR/iso3166.tab
	      Table of ISO 3166 2-letter country codes and country names.

       TZDIR/zone.tab
	      Table of country codes, latitude and longitude, TZ values, and descriptive comments.

       TZDIR/TZ
	      Time zone data file for time zone TZ.

EXIT STATUS

       The exit status is zero if a time zone was successfully obtained from the user, nonzero otherwise.

SEE ALSO

       newctime(3), tzfile(5), zdump(8), zic(8)

																       TZSELECT(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk for join

Discussion started by: repinementer

2. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

Discussion started by: InfoSeeker

3. Shell Programming and Scripting

Join using awk

Discussion started by: nbethy1

4. Shell Programming and Scripting

how to join two files with awk.

Discussion started by: ken002

5. Shell Programming and Scripting

left join using awk

Discussion started by: g1org1o

6. UNIX for Dummies Questions & Answers

Join or Awk

Discussion started by: jimmyf

7. UNIX for Dummies Questions & Answers

Join with awk different column

Discussion started by: radius

8. Shell Programming and Scripting

awk join 2 files

Discussion started by: vikus

9. Shell Programming and Scripting

Join two files using awk

Discussion started by: mystition

10. Shell Programming and Scripting

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

Discussion started by: yjacknewton

LEARN ABOUT REDHAT

tzselect