|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Left join on files using awk
Post 302320282 by radoulov on Wednesday 27th of May 2009 01:45:47 PM
05-27-2009
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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)
Discussion started by: InfoSeeker
3 Replies
2. Shell Programming and Scripting
So I have 2 files:
File 1:
111,Mike,Stipe
222,Peter,Buck
333,Mike,Mills
File 2:
222,Mr,Bono
444,Mr,Edge
I want output to be below, where 222 records joined and all none joined records still in output
111,Mike,Stipe
222,Peter,Buck,Mr,Bono
333,Mike,Mills
444,Mr,Edge (4 Replies)
Discussion started by: stack
4 Replies
3. Shell Programming and Scripting
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)
Discussion started by: ken002
6 Replies
4. Programming
I have a data table as follows:
mysql> select * from validations where source = "a03";
+------------+-------+--------+
| date | price | source |
+------------+-------+--------+
| 2001-01-03 | 80 | a03 |
| 2001-01-04 | 82 | a03 |
| 2001-01-05 | 84 | a03 |
| 2001-01-06... (2 Replies)
Discussion started by: figaro
2 Replies
5. Shell Programming and Scripting
Hi guys,
I need to use awk to join 2 files
file_1
A 001
B 002
C 003
file_2
A XX1
B XX2
output desired
A 001 XX1
B 002 missing
C 003 XX2
thank you! (2 Replies)
Discussion started by: g1org1o
2 Replies
6. Shell Programming and Scripting
Is it possible to join all the files with input1 based on 1st column?
input1
a
b
c
d
e
f
input2
a
b
input3
a
e
input4
c (2 Replies)
Discussion started by: quincyjones
2 Replies
7. Shell Programming and Scripting
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)
Discussion started by: g1org1o
2 Replies
8. Shell Programming and Scripting
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 ... (2 Replies)
Discussion started by: vikus
2 Replies
9. Shell Programming and Scripting
Hello All;
I have two files:
File1:
abc
def
pqr
File2:
abc,123
mno,456
def,989
pqr,787
ghj,678 (6 Replies)
Discussion started by: mystition
6 Replies
10. Shell Programming and Scripting
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)
Discussion started by: yjacknewton
2 Replies
LEARN ABOUT XFREE86
ucblinks
ucblinks(1B) SunOS/BSD Compatibility Package Commands ucblinks(1B) NAME
ucblinks - adds /dev entries to give SunOS 4.x compatible names to SunOS 5.x devices SYNOPSIS
/usr/ucb/ucblinks [-e rulebase] [-r rootdir] DESCRIPTION
ucblinks creates symbolic links under the /dev directory for devices whose SunOS 5.x names differ from their SunOS 4.x names. Where possi- ble, these symbolic links point to the device's SunOS 5.x name rather than to the actual /devices entry. ucblinks does not remove unneeded compatibility links; these must be removed by hand. ucblinks should be called each time the system is reconfiguration-booted, after any new SunOS 5.x links that are needed have been created, since the reconfiguration may have resulted in more compatibility names being needed. In releases prior to SunOS 5.4, ucblinks used a nawk rule-base to construct the SunOS 4.x compatible names. ucblinks no longer uses nawk for the default operation, although nawk rule-bases can still be specifed with the -e option. The nawk rule-base equivalent to the SunOS 5.4 default operation can be found in /usr/ucblib/ucblinks.awk. OPTIONS
-e rulebase Specify rulebase as the file containing nawk(1) pattern-action statements. -r rootdir Specify rootdir as the directory under which dev and devices will be found, rather than the standard root directory /. FILES
/usr/ucblib/ucblinks.awk sample rule-base for compatibility links ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWscpu | +-----------------------------+-----------------------------+ SEE ALSO
devlinks(1M), disks(1M), ports(1M), tapes(1M), attributes(5) SunOS 5.10 13 Apr 1994 ucblinks(1B)