05-07-2013
Radius,
Your specification is extremely vague. Is the 2nd field to be treated as
- a string (9C > 60C),
- a number followed by a character to be ignored (60C > 9C),
- a temperature in degrees (1C > 32F), or
- something else (???)?
If it is a temperature, are some values ever given in Fahrenheit or Kelvin? Does the sort need to convert Centigrade, Fahrenheit, and Kelvin to a common scale and sort by increasing temperatures independent of scale used? Or, will all temperatures be reported in Centigrade?
If it is something else, what?
So far, vidyadhar85's sort command assumes #2 and MadeInGermany's awk script assumes #1.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to do a grep with AND condition.
I have three files.
file1.txt
========
UNIX
......
WINDOWS
........
ORACLE
file2.txt
========
UNIX
.......
WINDOWS
...and many such files in a directory (6 Replies)
Discussion started by: prasperl
6 Replies
2. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
I have to grep a data file called datebook.txt. The last information in each line is a salary. I have to grep all the lines which precede those lines with 6 figure salaries. I can't SID it, or use Perl. It has to be grep (or egrep or... (3 Replies)
Discussion started by: DrSammyD
3 Replies
3. Shell Programming and Scripting
hi i need help with below code.
if ]
then
log "Exiting the script as ID= NULL"
log "Please run script first."
fi
i am calling grep inside this but its not running any ideas why ??
input file is like this --
Msg 102, Level 20, State 1:
Server... (4 Replies)
Discussion started by: dazdseg
4 Replies
4. Shell Programming and Scripting
Hi Folks!
I have a file like this
000000006 dist:0.0 FILE ./MintRoute/MultiHopWMEWMA.nc LINE:305:1 NODE_KIND:131 nVARs:4 NUM_NODE:66 TBID:733 TEID:758
000000000 dist:0.0 FILE ./Route/MultiHopLEPSM.nc LINE:266:1 NODE_KIND:131 nVARs:4 NUM_NODE:66 TBID:601 TEID:626
000000001 ... (2 Replies)
Discussion started by: jackoverflow
2 Replies
5. Shell Programming and Scripting
Hi,
my xml files looks something like this
<Instance Name="New York">
<Description></Description>
<Instance Name="A">
<Description></Description>
<PropertyValue Key="false" Name="Building A" />
</Instance>
<Instance Name="B">
... (4 Replies)
Discussion started by: tententen
4 Replies
6. Shell Programming and Scripting
Hi,
In this code can able to match the pattern without case sensitive. Is that possible?
if u knw plz help me...
code:
echo "Enter name to search"
read n
if ;
echo "name found"
else
echo "Not Found"
fi (8 Replies)
Discussion started by: boopal
8 Replies
7. Shell Programming and Scripting
Dear All,
I need help..
I am having a csv file.
Home_TITLE,People_TITLE,Repo_ALIAS
HMN5530,RKY5807,/mine_repo/rike001
HMN5530,SRY6443,/mine_repo/rike001
HMN5530,ARDY001,/mine_repo/rike001
If i have two value in varible RKY5807, HMN5530. how can fetch and store another value... (6 Replies)
Discussion started by: yadavricky
6 Replies
8. UNIX for Dummies Questions & Answers
hi all,
i have an xml what i have to do is to search for the source id(s1) and if it matches with that in xml then extract the file mask from the name of the file i.e if the file name is
idr_%YYYY%%MM%%DD%_%N%.idr then , i want the part after first %
and before last % ie in this case
... (5 Replies)
Discussion started by: ramsavi
5 Replies
9. UNIX for Dummies Questions & Answers
I have file input
AAAA_XX_Start> rlong . 0W
130526-11:36:13 10.128.13.226 9.0j RBS_NODE_MODEL_N_1_50 stopfile=/tmp/13019
..
=================================================================================================================
MO ... (2 Replies)
Discussion started by: radius
2 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)