Hi, I have used the following code to sort two sets of data:
awk '{printf "%10s %s\n",$1,$2}'
The first column is text and the second involves numbers. I was just wondering how i would go about sorting the second number so that they ascend from the top?
Thanks for any help (4 Replies)
i have following file have following type of data
1~%%~fcashfafh~%%~9797
can i sort(numeric) the file on first field and then on last feild using awk (3 Replies)
Hi guys,
Do you know how can I sort a file horizontally per line???
sample input file:
zebra papa dog apple
yahoo kangaroo ape
sample output:
apple dog papa zebra
ape kangaroo yahoo
Please post if u know the sed implementation of this (or whatever implementation u may know of)... (7 Replies)
Hi,
I have a file which is:-
1 6 4 8 2 3
2 1 9 3 2 1
3 3 5 6 3 1
4 9 7 8 2 3
I would like to sort from field $2 to field $6 for each of the line to:-
1 2 3 4 6 8
2 1 1 2 3 9
3 1 3 3 5 6
4 2 3 7 8 9
I came across this Arrays on example 26-6. But it is much complicated. I am... (7 Replies)
Little-bit of awk experience, need some of the expert help on here. Browsed around here, got a little further, but I am still missing some pieces. Can you help me fill-in my missing awk cells?
Sample data file (leaving out ","'s):
Column 1 Column 2 Column 3 Column 4 ... (10 Replies)
sed '$!N; /^\(.*\)\n\1$/!P; D'
i found this file which removes duplicates irrespective for sorted or unsorted file. keep first occurance and remove the further occurances.
can any1 explain how this is working..
i need to remove duplicates following file. duplicate criteria is not the... (3 Replies)
Hello all, I am new here and *relatively* new to Unix. I have a bit of an emergency. I have a three column file that I need to sort:
sample name, miRNA, reads per million (RPM)
There are multiple samples, and for each sample name there are multiple miRNAs and associated RPMs. Some of these... (6 Replies)
Hello,
I have a file which has the following format: I have to do is sort individual records in the file based on the 4th field. Each record starts with "Module". Is there an easy way to do this using awk. I have tried piping output from awk to sort and also using "sort" inside awk but... (8 Replies)
S 0.0 0.0 (reg, inst050)
k
e
f
d
c
S 0.0 0.0 (mux, m030)
k
g
r
s
x
v
S 0.0 0.0 (reg, inst020)
q
s
n
m (12 Replies)
Discussion started by: ctphua
12 Replies
LEARN ABOUT REDHAT
drop_operator_class
DROP OPERATOR CLASS(7) SQL Commands DROP OPERATOR CLASS(7)NAME
DROP OPERATOR CLASS - remove a user-defined operator class
SYNOPSIS
DROP OPERATOR CLASS name USING access_method [ CASCADE | RESTRICT ]
INPUTS
name The name (optionally schema-qualified) of an existing operator class.
access_method
The name of the index access method the operator class is for.
CASCADE
Automatically drop objects that depend on the operator class.
RESTRICT
Refuse to drop the operator class if there are any dependent objects. This is the default.
OUTPUTS
DROP OPERATOR CLASS
The message returned if the command is successful.
DESCRIPTION
DROP OPERATOR CLASS drops an existing operator class from the database. To execute this command you must be the owner of the operator
class.
NOTES
The DROP OPERATOR CLASS statement is a PostgreSQL language extension.
Refer to CREATE OPERATOR CLASS [create_operator_class(7)] for information on how to create operator classes.
USAGE
Remove B-tree operator class widget_ops:
DROP OPERATOR CLASS widget_ops USING btree;
This command will not execute if there are any existing indexes that use the operator class. Add CASCADE to drop such indexes along with
the operator class.
COMPATIBILITY
SQL92
There is no DROP OPERATOR CLASS in SQL92.
SQL - Language Statements 2002-11-22 DROP OPERATOR CLASS(7)