02-21-2005
bhargav,
You mind to elaborate on the code? I am not familiar with awk so I am not quite sure what are those number are, and "file1" is the name of the file you open or the file you put the output to?
Thanks
CT
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
All
Iam using Korne shell in AIX OS. Can u give me the syntax to send a mail.
Thanx in advance
Regards
Deepak (5 Replies)
Discussion started by: DeepakXavier
5 Replies
2. Shell Programming and Scripting
All
Please help to provide "goto" functionality in KORN shell script.
ex:
1: Command
Process some command
if check some variable
true
goto 1
else
process some other
Please help to implement this example in korne... (1 Reply)
Discussion started by: DeepakXavier
1 Replies
3. Shell Programming and Scripting
is there any way to format a file by just removing first line and last line from the file.
my file is like
test.txt
12may2004,20may2004,A
123,SCOTT,TIGER,,,,12,12-MAY-2006
124,TIGER,SCOTT,,,,,,,
....
...
163,cscssaa,abc,,,,12,12-MAY-2006
END
my requirement is to produce the same file... (1 Reply)
Discussion started by: u263066
1 Replies
4. Shell Programming and Scripting
Hi Everyone,
I have tried with the following Code for each of the following, but that does not seem to serve the purpose. Can someone give some pointers please.
1) A Korne Shell which asks the user to enter the name of a file when searching it
recursively (using the find command) in the... (3 Replies)
Discussion started by: marconi
3 Replies
5. Shell Programming and Scripting
I am new to Korne Shell Scripting. Can someone help me with a Korne Shell which asks the user :-
1) to enter the name of a file when searching it recursively (using the find
command) in the home directory of this user.
2) for a date (format AAMMJJ) and a directory and then searches ... (4 Replies)
Discussion started by: marconi
4 Replies
6. Shell Programming and Scripting
In Korne Shell Scripting, how to search recursively in a directory, the list of files modified after a given date ..
Thanks in advance.. (1 Reply)
Discussion started by: marconi
1 Replies
7. Shell Programming and Scripting
I am trying to write a Korne Shell asking the user for a date and a directory and then search recursively in this directory the list of files modified after the date chosen. But I am not getting good results when I Test it...
#!/usr/bin/ksh
echo "Enter a date (YYYYMMDD) "
read date
touch -t... (2 Replies)
Discussion started by: marconi
2 Replies
8. Shell Programming and Scripting
Hi,
I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix.
My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies
9. Shell Programming and Scripting
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 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)