Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
February 2, 2005, 11:08 pm
rate this thread
i have a small file (20k) that looks like the following. some fields have 1
space between them, others 2, others more. (. = space)
00290..S.....33.XS798............SUB.......SUB ACTIVE 19971202
00090..S.... 69KV..TSS30 TR LTC TR2 ACTIVE 20050201
00135..S.... 69KV..TSS30 TRLTC TR1 ACTIVE 20050201
the problem is that when i do the following
sort +2 -3 it works the 3rd the list is correctly sorted in the third column.
however, if I want to sort on the 4 colum and do
sort +4 -5 it does not work (see example above), it sorts by the 4th column
only in relation to the 3rd column (x goes first because of the 33), howve i
think it might be related to the 1 vs. 2 spaces.
I though about replacing the spaces with tabs, however some of the fields have
spaces within them leading to problems with alignment.
i also tried
sort -n -k 5,5 -k 4,4 -k 6,6 but that didn't work only if i stoped after
It seems like the problem is that after field 3 there are differing amounts of
space between fields .
Can Perl Sort do this, new to perl. any help greated appreciated.
Re: can Perl Sort do this, unix sort breaks on it (muliple spacesas demiliter)
> Can Perl Sort do this, new to perl. any help greated appreciated.
Yes, Perl can help you;
perldoc -f sort
perldoc -q sort
"I know not with what weapons World War 3 will be fought, but World War
4 will be fought with sticks and stones." (Albert Einstein)
- » FAQ 4.22 How do I expand function calls in a string?
- — Previous thread in » PERL Discussions