07-28-2012
Thank you very much but can u just explain me how that works? if i have to join two lines of same file based on common 1st field how do i do that? the exact opposite of previous one
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have this sample data:
test01 --- abc-01 name1
abc-02 name2
abc-03 name3
test02 --- abc-20 name4
abc-21 name5
test03 --- abc-22 name6
abc-23 name7
i want to generate a file... (13 Replies)
Discussion started by: inquirer
13 Replies
2. Shell Programming and Scripting
Hello ALL,
I really need help to grep data and store in particular format. I am struggling to write that script .Please help me to solve this problem otherwise i will loose my job...
I have to compare 2 files and generate the staticts of the data.
First file product.dat contains 2 column . ... (4 Replies)
Discussion started by: getdpg
4 Replies
3. Shell Programming and Scripting
Hi All,
I'm using the following script to produce a result:
#!/bin/sh
awk ' $0 ~ /\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+Interface\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+\+/ {
match_str="YES"; line_cnt=0; next; }
{
if((line_cnt < 5) && ( match_str=="YES"))
{
print $0;
line_cnt += 1;
}
else... (0 Replies)
Discussion started by: ntgobinath
0 Replies
4. Shell Programming and Scripting
Dear Members,
I have string like this
string1="file2.txt file4.txt kittu.txt file1.txt"
in this i need to cut spaces and take each one has one file
output should be
---------
fileslist:4
file2.txt
file4.txt
kittu.txt
file1.txt
is it possible, please tell me how it possible
... (5 Replies)
Discussion started by: kittusri9
5 Replies
5. Shell Programming and Scripting
Hi guys,
i have a problem which im hoping you will be able to help me with.
I have follwing output :-
-------------------------------------------------------------------------------
NSTEP = 407000 TIME(PS) = 43059.000 TEMP(K) = 288.46 PRESS = 0.0
Etot = -2077.4322 ... (2 Replies)
Discussion started by: Mish_99
2 Replies
6. Shell Programming and Scripting
In a bash script, I'm looking for a way to set each matching line of a file into its own variable, or variable array.
As an example, i have a crontab file with several entries:
00 23 * * * /usr/local/bin/msqlupdate -all
00 11 * * * /usr/local/bin/msqlupdate -inc
00 03 * * *... (2 Replies)
Discussion started by: lochraven
2 Replies
7. Shell Programming and Scripting
Hi,
I have a string as
str="route net,-hopcount,1,255.255.255.0,10.230.20.111,10.230.20.234 Route True route net,-hopcount,0,-netmask,255.255.248.0,0,10.230.23.254 Route True"
I need to split this string into two lines as
route net,-hopcount,1,255.255.255.0,10.230.20.111,10.230.20.234... (4 Replies)
Discussion started by: chaitanyapn
4 Replies
8. Programming
hi this is a problem statement i have tried real hard but could not come up with a satisfactory program can someone help
you are to create a pair of programs that do the following in this order:
1 one of the program creates a FIFO which another program should be able to write into
2 the... (2 Replies)
Discussion started by: puneetparnani
2 Replies
9. High Performance Computing
we have one file (11 Million) line that is being matched with (10 Billion) line.
the proof of concept we are trying , is to join them on Unix :
All files are delimited and they have composite keys..
could unix be faster than Oracle in This regards..
Please advice (1 Reply)
Discussion started by: magedfawzy
1 Replies
10. UNIX for Dummies Questions & Answers
Hi all
I need your help to separate colomns based on "-" delimiter for a very big file 30 millions rows
I have a colmun looking like this :
clomun 1
1-100000989-A_ATC
1-10000179-AAAAA
1-100002154-TGTTA
1-100002155-GTTAG
1-100002443
1-100002490
1-100002619
I need to separte in three... (5 Replies)
Discussion started by: biopsy
5 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specifed in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
JOIN(1)