|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
sed or awk to order a file
Post 302324553 by sniper57 on Thursday 11th of June 2009 04:53:43 AM
06-11-2009
sed or awk to order a file
Hi -
I have a file with lots of lines in that I need to order based on the number of commas!
e.g the file looks something like :-
cn=john,cn=users,cn=uk,dc=dot,dc=com
cn=john,cn=users,dc=com
cn=users,cn=groups,dc=com
cn=john,cn=admins,cn=users,cn=uk,dc=dot,dc=com
cn=fred,cn=users,cn=uk,dc=dot,dc=com
cn=simon,cn=users,cn=uk,dc=dot,dc=com
cn=users,dc=com
I need to order the file so that it ends up like :-
cn=john,cn=admins,cn=users,cn=uk,dc=dot,dc=com
cn=john,cn=users,cn=uk,dc=dot,dc=com
cn=fred,cn=users,cn=uk,dc=dot,dc=com
cn=simon,cn=users,cn=uk,dc=dot,dc=com
cn=john,cn=users,dc=com
cn=users,cn=groups,dc=com
cn=users,dc=com
I am hoping someone knows some sed or awk that can do this ?
Many thanks
I have a file with lots of lines in that I need to order based on the number of commas!
e.g the file looks something like :-
cn=john,cn=users,cn=uk,dc=dot,dc=com
cn=john,cn=users,dc=com
cn=users,cn=groups,dc=com
cn=john,cn=admins,cn=users,cn=uk,dc=dot,dc=com
cn=fred,cn=users,cn=uk,dc=dot,dc=com
cn=simon,cn=users,cn=uk,dc=dot,dc=com
cn=users,dc=com
I need to order the file so that it ends up like :-
cn=john,cn=admins,cn=users,cn=uk,dc=dot,dc=com
cn=john,cn=users,cn=uk,dc=dot,dc=com
cn=fred,cn=users,cn=uk,dc=dot,dc=com
cn=simon,cn=users,cn=uk,dc=dot,dc=com
cn=john,cn=users,dc=com
cn=users,cn=groups,dc=com
cn=users,dc=com
I am hoping someone knows some sed or awk that can do this ?
Many thanks
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
so i have been trying to learn how to manipulate text on my own and have gotten stumped...
let's say i have a text file that says (highly simplified):
people ordinary
How would swap the order of the words..
I know i need to use sed and some kind of back reference but cannot make it... (2 Replies)
Discussion started by: urtherhoda
2 Replies
2. UNIX for Dummies Questions & Answers
I have a text
"abc def ghi"
and I want to get it as
"def abc ghi"
I am using this
echo "abc def ghi" | sed 's/\(*\)\(*\)/\2\1/'
But I am not able to get the output, could anyone help me.
Thanks (9 Replies)
Discussion started by: venu_nbk
9 Replies
3. Shell Programming and Scripting
I'm hoping someone can help me on this. I have a data file that greatly simplified might look like this:
sec;src;dst;proto
421;10.10.10.1;10.10.10.2;tcp
426;10.10.10.3;10.10.10.4;udp
442;10.10.10.5;10.10.10.6;tcp
sec;src;fac;dst;proto
521;10.10.10.1;ab;10.10.10.2;tcp... (3 Replies)
Discussion started by: eric4
3 Replies
4. Shell Programming and Scripting
Im trying to develop a shell script that will change the content order of the file.
For example I have a file that says
a
b
c
d
I want to change this to be
d
c
b
a
Im trying to use sed to this by reading the file and then inserting each line at the top
#!/usr/bin/ksh
... (3 Replies)
Discussion started by: MBGPS
3 Replies
5. Shell Programming and Scripting
Hi Everyone,
I am new to this forum and new to sed/awk programming too !!
I need to find particular string in file1(text file) and replace it with a value from another text file(file2) the file2 has only one line and the value to be replaced with is in the second column.
file 1:
(assert (=... (21 Replies)
Discussion started by: paramad
21 Replies
6. Shell Programming and Scripting
Hi, i have a strange prob. log file contains ip, protocol, user name, agent . these can be in any order. If log contains the above order able to fetch all details but if details are in diff order not able to fetch all details.
using below command.
grep -A50 "Entry " "/logs/file.log" \
|grep... (6 Replies)
Discussion started by: Satyak
6 Replies
7. Shell Programming and Scripting
Hello.
I would like to write a bash function which would return "true" if the search succeed else return anything else.
something like
if ] ; then
exit 1
fi
function my_funct () {
find first occurrence $2 in $1
if not found return "false"
from that position,... (6 Replies)
Discussion started by: jcdole
6 Replies
8. Shell Programming and Scripting
I have this END section in an awk script:
END {
for (j in littlebin)
{
print (j, int(log(j)/log(2)) , littlebin)
lbsum+=littlebin
}
for (i in bins)
... (6 Replies)
Discussion started by: treesloth
6 Replies
9. Shell Programming and Scripting
is it possible to order the following row clusters from ascending to descending. thanx in advance
input
1 2 4 0
1 2 4 0
3 3 3 3
1 5 1 0
1 5 1 0
6 0 0 0
5 1 1 1... (4 Replies)
Discussion started by: quincyjones
4 Replies
10. UNIX for Beginners Questions & Answers
Dear Users,
Appreciate your help if you could help me with splitting a large file > 1 million lines with sed or awk. below is the text in the file
input file.txt
scaffold1 928 929 C/T +
scaffold1 942 943 G/C +
scaffold1 959 960 C/T +... (6 Replies)
Discussion started by: kapr0001
6 Replies
LEARN ABOUT DEBIAN
users-admin
users-admin(1) General Commands Manual users-admin(1) NAME
users-admin - Users Administration Tool SYNOPSIS
users-admin [OPTION...] DESCRIPTION
users-admin is part of the GNOME system tools, a set of tools to easily access and manage system configuration. users-admin allows you add, delete and modify the existing users and groups in your system. OPTIONS
users-admin accepts the standard GNOME and GTK options. AUTHORS
users-admin was written by Carlos Garnacho Parro <garnacho@tuxerver.net> and others. This manual page was written by Sven Arvidsson <sa@whiz.se>, for the Debian project (but may be used by others). SEE ALSO
services-admin(1), network-admin(1), time-admin(1), shares-admin(1), gtk-options(7), gnome-options(7) The online documentation available through the program's Help menu. GNOME
2007-05-08 users-admin(1)