01-24-2006
sorry i didnt put space that's why it was giving me error
the first command is working..
but i am not getting number of failes .. because it is in second line ..
i am getting colunm 7 and 8 ..
can you tell me how to join the 2 lines..
i think i have to join first lines and then cut the data from file ..
pls write back
and thanks for helping me
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a file which contains more than 1 lakh records like following:
a. name, id, city, state, country, phone (Expected I/P file format)
name, id, city,, state, country, phone (Current I/P file format )
I want to achieve following tasks,
a, Remove the extra comma in the... (1 Reply)
Discussion started by: velappangs
1 Replies
2. Shell Programming and Scripting
hi ,
i need to format the output which is availble in a file
file output is
Following are the Process_Scheduler Domains running in the server Ram-pc
VPORCL
Following are the Application Server domains running in the server Ram-pc
VPORCL01
VPORCL02
these value VPORCL,VPORCL01...... (5 Replies)
Discussion started by: becksram123
5 Replies
3. Shell Programming and Scripting
Hi,
I am trying to put a script together that allows for a command to be executed and then the output goes to a .html file. I am running the script on HPUX.
I run:
/var/fl/user/lmutil lmstat -a -c license_lic.dat > /web/results.html
This saves the command to a .html file but the text is... (1 Reply)
Discussion started by: zerbitated
1 Replies
4. Shell Programming and Scripting
I am sending the output of a file to .csv file.
The output should look like this:
Total Customers Processed:,8
Total Customers Skipped:,0
Total Customers Added:,8
Total Customers Changed:,0
Total Policies Deleted:,0
Total Policies Failed:,0
total:,8
Now i want this output in... (1 Reply)
Discussion started by: Prashant Jain
1 Replies
5. Shell Programming and Scripting
I have a file which has following contents
usmtnz-dinfsi19
62
61
18400
18800
99.7
usmtnz-dinfsi19
62
61
18400
18800
99.7
i want the o/p to be like
date (7 Replies)
Discussion started by: fugitive
7 Replies
6. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
7. Shell Programming and Scripting
Dear Master.
Help me to command to out put.
Ex log.
"<?xml version=""1.0"" encoding=""UTF-10"" ?><anova-test-bom>
<txid>17251032659</txid>
<authentication>
<user>admin</user>
<password>Amrduoi</password>
</authentication>
<destination>
<msisdn>1111111</msisdn>
... (2 Replies)
Discussion started by: ooilinlove
2 Replies
8. Shell Programming and Scripting
hi
i need some help over here.. please help
i have a log file as per below
---------------------------------------------------------------------------------------------------------
JOB START DATE : 20110510204513
JOB ID : us2cap3ds9... (6 Replies)
Discussion started by: sitaldip
6 Replies
9. Shell Programming and Scripting
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
10. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [-an] [-e s] [-o list] [-tc] 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.
-o list
Each output line comprises the fields specified 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.
7th Edition April 29, 1985 JOIN(1)