09-27-2007
Help needed to sort file
I have a text file comprising of 3 columns
1. First column - numeric count/frequency of error codes
2. Second column - alphanumeric hyphenated error code
3. Third column - Error code description (alphanumeric)
184 ABCD-954 Errorcodedescription1
35645 DFMS-323 Errorcodedescription2
43534 XCVW-8793 Errorcodedescription3
56743 MWDS-234 Errorcodedescription4
I would like to sort this file in ascending order of the numeric portion of the errorcode above (the numeric part after the hyphen in the error code above e.g. it would be 954 for the first line above)
So the output should look like this :
56743 MWDS-234 Errorcodedescription4
35645 DFMS-323 Errorcodedescription2
184 ABCD-954 Errorcodedescription1
43534 XCVW-8793 Errorcodedescription3
Apparently I am not able to use any options of the sort command.
Any help will be really appreciated!
thanks
Indi
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am facing a small problem while I am doing the sort.
Problem Definition:
I have a file which has the following data.
>cat test.dat
zxzxc
asdasd
qwaxcZa
qwaxcA
When I do a sort on this file.
the result set is
asdasd
qwaxcA (4 Replies)
Discussion started by: Andysundar
4 Replies
2. UNIX for Dummies Questions & Answers
Suppose I want to find the number of uniq lines in a file. I use the following command:
sort file1 | uniq -c | wc -l
But if for some reason sort fails, the above command returns 0 as the answer.
Why would sort fail ? sort makes use of directories /tmp or /var/tmp to store temporary files.... (7 Replies)
Discussion started by: the_learner
7 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I would like to know given that I have 3 columns.
Let say I have first 3 columns to do operation and these operation output is printed out each line by line using AWK and associative array.Currently in the output file, I do a sort by -r for the operation output.
The problem comes to... (1 Reply)
Discussion started by: ahjiefreak
1 Replies
4. Shell Programming and Scripting
Hello,
suppose i have a student.dat file whose format is
studentno studentname semester marks1 marks2 marks3 total
then how can i sort first in semester wise and then total wise? I mean semester wise ranking wise record should be displayed. Semester should be displayed in ascending order... (6 Replies)
Discussion started by: salman4u
6 Replies
5. Shell Programming and Scripting
Hi All,
After Sorting directories and files i have got following output as below, now i only want the strings common in them, so the actual output should be as below in the bottom. How do i do that?
Thanks
-adsi
File to be modified:-
Common Components for ----> AA... (4 Replies)
Discussion started by: asirohi
4 Replies
6. Shell Programming and Scripting
Hello All,
Today i have been asking lots of question, hope to become good in scripting soon with all the wonderful advices i get. The question is i want to sort data a get uniq string from it. The code i am using to generate the output is:-
check_sun() {
for i in $SUN_PLATFORM
do
$ECHO... (0 Replies)
Discussion started by: asirohi
0 Replies
7. UNIX for Advanced & Expert Users
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies
8. Shell Programming and Scripting
I have a file with three fields of data for example say we have
1420 $12.56 45
3456 $15.89 14
2341 $25.87 32
I need to use a command to show who is getting paid the highest amount to standard output. I am not sure if I should use a sort command or a copy and paste... (1 Reply)
Discussion started by: drew211
1 Replies
9. Shell Programming and Scripting
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies
10. UNIX for Beginners Questions & Answers
I have a csv file as shown below,
xop_thy 80 avr_njk 50 str_nyu 60
avr_irt 70 str_nhj 60 avr_ngt 50
str_tgt 80 xop_nmg 50 xop_nth 40
cyv_gty 40 cop_thl 40 vir_tyk 80
vir_plo 20 vir_thk 40 ijk_yuc 70
cop_thy 70 ijk_yuc 80 irt_hgt 80
I need to align/sort the csv file based... (7 Replies)
Discussion started by: dineshkumarsrk
7 Replies
LEARN ABOUT FREEBSD
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7).
EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BUGS
Input lines are limited to LINE_MAX (2048) bytes in length.
BSD
July 29, 2004 BSD