12-15-2008
alphanumeric Sorting
Hi ,
I have a requirement where one column have to be sorted (delimiter is pipe)
for eg:
My input filed is as below
1|FIAT|0010103|23011|01/01/2000|31/12/9999|1.15
2|232|613|1
2|234|743|1
2|234|793|1
2|234|893|1
1|FIAT|0010103|23012|01/01/2000|31/12/9999|1.15
2|230|006|0
2|230|106|0
2|230|116|0
2|230|716|0
1|FIAT|0010103|113013|01/01/1996|31/12/9999|1.15
2|231|966|0
2|232|747|0
1|FIAT|0010103|123014|01/01/2000|31/12/9999|1.15
2|232|717|0
2|232|718|0
2|232|728|0
2|232|818|0
I need to do alphanumeric (dictionary) sort for all the columns marked in red for only thoes record which start with '1'. Record '1' should followed by all thoes which start with '2'
and my desired out put is
1|FIAT|0010103|113013|01/01/1996|31/12/9999|1.15
2|231|966|0
2|232|747|0
1|FIAT|0010103|123014|01/01/2000|31/12/9999|1.15
2|232|717|0
2|232|718|0
2|232|728|0
2|232|818|0
2|232|827|0
2|232|828|0
1|FIAT|0010103|23011|01/01/2000|31/12/9999|1.15
2|232|613|1
2|234|743|1
2|234|793|1
2|234|893|1
1|FIAT|0010103|23012|01/01/2000|31/12/9999|1.15
2|230|006|0
2|230|106|0
2|230|116|0
2|230|716|0
Is ther any command to sort such kind of input data?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file I'm trying to sort such as
fred1
fred2
fred10
fred11
...
when I sort I get
fred1
fred10
fred11
fred2
...
using sort can any give me the syntax to sort this is dict order
e.g., (4 Replies)
Discussion started by: gefa
4 Replies
2. Shell Programming and Scripting
I have a requirement where I need to check if
where r1v07l09ab is a software release.
I should always check for this to be true to continue the release deployment because an older release should not be deployed by mistake. I mean only the release greater than the current release should be... (3 Replies)
Discussion started by: rakeshou
3 Replies
3. Shell Programming and Scripting
Hi guys, I'm new to this forum and I'm not a UNIX expert. I can't figure out this certain problem i'm having:
I need to sort some words, some of the words are annotations (enclosed within < and >). I need to have them sorted alphabetically with all non-alphanumeric characters up front. For... (2 Replies)
Discussion started by: fed.m.ang
2 Replies
4. Shell Programming and Scripting
Hi!
Could anyone so kindly help me a code to eliminate from a txt file, obtained by collecting and merge several web-page, every word (string) containing non alphabetical, numeric and punctuation character (i.e NON a-zA-Z0-9, underscore and punctuation mark)?
Thanks a lot for the help to... (5 Replies)
Discussion started by: mjomba
5 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am having a data file which consists of lakhs of records in the below foramt:
"1223323","4341341","discription aadfad"
"3123123","5463456","discription aadfad"
"2343324","6565767","discription asdfads"
"A3423423","7957456","discription aadfad"
"343453B","7957456","discription... (1 Reply)
Discussion started by: abhi_123
1 Replies
6. Shell Programming and Scripting
Hi folks,
I have a value like A12,i could able to change this into integer using typeset as below
typeset -i A12
But, I need your advice to change the values like 1A2 or 12A into integer.
Thanks in advance.
Thanks,
Sathish (3 Replies)
Discussion started by: bsathishmca
3 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I have files with a column which has values and ranges, for example
colA colB
ERD1 3456
ERD2
ERD3 4456
I want to have the following output
colA colB colC
ERD1 3456 3456
ERD2 526887 526890
ERD3 4456 4456
Being a newbie to... (2 Replies)
Discussion started by: alpesh
2 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I want sort following files in ascending order.
exp_installer_CC4160-file10.dmp
exp_installer_CC4160-file11.dmp
exp_installer_CC4160-file12.dmp
exp_installer_CC4160-file13.dmp... (3 Replies)
Discussion started by: gramakrishna
3 Replies
9. Shell Programming and Scripting
Good evening to all!!
I'm facing this problem:
I saved in a txt a list of files name (one txt for every folder):
hello0.jpg
hello1.jpg
hello10.jpg
hello11.jpg
hello12.jpg
hello13.jpg
hello14.jpg
hello15.jpg
hello16.jpg
hello17.jpg
hello18.jpg
hello19.jpg
hello2.jpg
hello20.jpg... (32 Replies)
Discussion started by: silver18
32 Replies
10. Shell Programming and Scripting
I have a lot of data that need to be sorted alphanumerically. I began using sort -du and it solved almost all my problems. However, when I encountered files with data like this it began to fail:
/vol/close_eng_ice_0888
/vol/open_eng_ice_0890
/vol/open_eng_ice_08923
/vol/open_eng_ice_0893... (6 Replies)
Discussion started by: newbie2010
6 Replies
LOOK(1) BSD General Commands Manual LOOK(1)
NAME
look -- display lines beginning with a given string
SYNOPSIS
look [-bdf] [-t termchar] string [file ...]
DESCRIPTION
The look utility displays any lines in file which contain string as a prefix.
If file is not specified, the file /usr/share/dict/words is used, only alphanumeric characters are compared and the case of alphabetic char-
acters is ignored.
The following options are available:
-b, --binary
Use a binary search on the given word list. If you are ignoring case with -f or ignoring non-alphanumeric characters with -d, the
file must be sorted in the same way. Please note that these options are the default if no filename is given. See sort(1) for more
information on sorting files.
-d, --alphanum
Dictionary character set and order, i.e., only alphanumeric characters are compared.
-f, --ignore-case
Ignore the case of alphabetic characters.
-t, --terminate termchar
Specify a string termination character, i.e., only the characters in string up to and including the first occurrence of termchar are
compared.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of the look utility. Their effect is described in environ(7).
FILES
/usr/share/dict/words the dictionary
EXIT STATUS
The look utility exits 0 if one or more lines were found and displayed, 1 if no lines were found, and >1 if an error occurred.
COMPATIBILITY
The original manual page stated that tabs and blank characters participated in comparisons when the -d option was specified. This was incor-
rect and the current man page matches the historic implementation.
look uses a linear search by default instead of a binary search, which is what most other implementations use by default.
The -a and --alternative flags are ignored for compatibility.
SEE ALSO
grep(1), sort(1)
HISTORY
A look utility appeared in Version 7 AT&T UNIX.
BUGS
Lines are not compared according to the current locale's collating order. Input files must be sorted with LC_COLLATE set to 'C'.
BSD
July 17, 2004 BSD