How about this abbreviated version:
It collects the file2's second fields into the A array, and then prints file1's lines adding A's contents is exists or nothing if A[$2] is empty/does not exist.
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 (1 Reply)
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 Replies)
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... (7 Replies)
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,... (6 Replies)
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 (2 Replies)
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... (1 Reply)
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 (3 Replies)
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... (2 Replies)