Sponsored Content
Top Forums UNIX for Dummies Questions & Answers sort by column or specific order Post 302322482 by hegdeshashi on Thursday 4th of June 2009 12:41:05 AM
Old 06-04-2009
sort by column or specific order

Hi,

I need to sort it by column or need it in a specific order...

input is
=====
uid=shashi country= india region =0 ph=0
uid= jon region= asia ph= 12345 country=0
uid = man country= india ph=2222 region=0
uid= neera region= asia ph= 125 country=0

output should be

uid=shashi country= india region =0 ph=0
uid= jon country=0 region= asia ph= 12345
uid = man country= india region=0 ph=2222
uid= neera country=0 region= asia ph= 125
======

thanks in advance...
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sort - original order .... Help

Hi all, I want to sort a file based on the number in the 9th column I've tried both of the following commands sort -k 9,9n file_to_sort.dat sort +8 -n file_to_sort.dat both resulting in the same output which does sort col 9 nummerically but it doesn't output the lines in the original... (2 Replies)
Discussion started by: olga
2 Replies

2. Shell Programming and Scripting

SORT order in Unix

I am converting mainframes JCL to be used in shell on a one to one basis... when i use the sort command unix does ascii sort as a result which numbers are first followed by charecters in the Ascending sort ... but themainframes uses the EBCDIC as result gives the charecters followed by numbers in... (5 Replies)
Discussion started by: bourne
5 Replies

3. Shell Programming and Scripting

How to manipulate first column and reverse the line order in third and fourth column?

How to manipulate first column and reverse the line order in third and fourth column as follws? For example i have a original file like this: file1 0.00000000E+000 -1.17555359E-001 0.00000000E+000 2.00000000E-002 -1.17555359E-001 0.00000000E+000 ... (1 Reply)
Discussion started by: Max Well
1 Replies

4. Shell Programming and Scripting

Question about sort specific column and print other column at the same time !

Hi, This is my input file: ali 5 usa abc abu 4 uk bca alan 6 brazil bac pinky 10 utah sdc My desired output: pinky 10 utah sdc alan 6 brazil bac ali 5 usa abc abu 4 uk bca Based on the column two, I want to do the descending order and print out other related column at the... (3 Replies)
Discussion started by: patrick87
3 Replies

5. UNIX for Dummies Questions & Answers

How to sort a column based on numerical ascending order if it includes e-10?

I have a column of numbers in the following format: 1.722e-05 2.018e-05 2.548e-05 2.747e-05 7.897e-05 4.016e-05 4.613e-05 4.613e-05 5.151e-05 5.151e-05 5.151e-05 6.1e-05 6.254e-05 7.04e-05 7.12e-05 7.12e-05 (6 Replies)
Discussion started by: evelibertine
6 Replies

6. Shell Programming and Scripting

comparing column of two different files and print the column from in order of 2nd file

Hi friends, My file is like: Second file is : I need to print the rows present in file one, but in order present in second file....I used while read gh;do awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile done < secondfile but the output I am... (14 Replies)
Discussion started by: CAch
14 Replies

7. Shell Programming and Scripting

Sort numeric order

Hi I am using this cat substitutionFeats.txt | gawk '{$0=gensub(/\t/,"blabla",1);print}' | gawk '{print length, $0}' | sort -n | sort -r and the "sort -n" command doesn't work as expected: it leads to a wrong ordering: 64 Adjustable cuffs 64 Abrasion- 64 Abrasion pas 647 Sanitized 647... (4 Replies)
Discussion started by: louisJ
4 Replies

8. Shell Programming and Scripting

Sort by specific order?

Hello all I was wondering if someone has an idea how to sort by a specific order, let's say by a specific alphabet containing only 4 letters like (d,s,a,p) instead of (a,b,c....z) ?? Cheers! (6 Replies)
Discussion started by: cabrao
6 Replies

9. Shell Programming and Scripting

Help with sort alphabet on specific column

Input file: POL B7U6K8 Avian_reticuloendotheliosis_virus POLB B7Z1W5 Homo_sapiens POLB H9G5Y0 Anolis_carolinensis POLD1 Q642R8 Xenopus_laevis POLD2 H0YZC7 Taeniopygia_guttata POLD3 F1P540 Gallus_gallus POLDIP3 Q5F4B6 Gallus_gallus POLE2 E1C2T8 Gallus_gallus... (3 Replies)
Discussion started by: perl_beginner
3 Replies

10. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies
Regexp::Common::zip(3)					User Contributed Perl Documentation				    Regexp::Common::zip(3)

NAME
Regexp::Common::zip -- provide regexes for postal codes. SYNOPSIS
use Regexp::Common qw /zip/; while (<>) { /^$RE{zip}{Netherlands}$/ and print "Dutch postal code "; } DESCRIPTION
Please consult the manual of Regexp::Common for a general description of the works of this interface. Do not use this module directly, but load it via Regexp::Common. This module offers patterns for zip or postal codes of many different countries. They all have the form "$RE{zip}{Country}[{options}]". The following common options are used: "{-prefix=[yes|no|allow]}" and "{-country=PAT}". Postal codes can be prefixed with a country abbreviation. That is, a dutch postal code of 1234 AB can also be written as NL-1234 AB. By default, all the patterns will allow the prefixes. But this can be changed with the "-prefix" option. With "-prefix=yes", the returned pattern requires a country prefix, while "-prefix=no" disallows a prefix. Any argument that doesn't start with a "y" or a "n" allows a country prefix, but doesn't require them. The prefixes used are, unfortunally, not always the same. Officially, ISO country codes need to be used, but the usage of CEPT codes (the same ones as used on cars) is common too. By default, each postal code will recognize a country prefix that's either the ISO standard or the CEPT code. That is, German postal codes may prefixed with either "DE" or "D". The recognized prefix can be changed with the "-country" option, which takes a (sub)pattern as argument. The arguments "iso" and "cept" are special, and indicate the language prefix should be the ISO country code, or the CEPT code. Examples: /$RE{zip}{Netherlands}/; # Matches '1234 AB' and 'NL-1234 AB'. /$RE{zip}{Netherlands}{-prefix => 'no'}/; # Matches '1234 AB' but not 'NL-1234 AB'. /$RE{zip}{Netherlands}{-prefix => 'yes'}/; # Matches 'NL-1234 AB' but not '1234 AB'. /$RE{zip}{Germany}/; # Matches 'DE-12345' and 'D-12345'. /$RE{zip}{Germany}{-country => 'iso'}/; # Matches 'DE-12345' but not 'D-12345'. /$RE{zip}{Germany}{-country => 'cept'}/; # Matches 'D-12345' but not 'DE-12345'. /$RE{zip}{Germany}{-country => 'GER'}/; # Matches 'GER-12345'. "{-sep=PAT}" Some countries have postal codes that consist of two parts. Typically there is an official way of separating those parts; but in practise people tend to use different separators. For instance, if the official way to separate parts is to use a space, it happens that the space is left off. The "-sep" option can be given a pattern as argument which indicates what to use as a separator between the parts. Examples: /$RE{zip}{Netherlands}/; # Matches '1234 AB' but not '1234AB'. /$RE{zip}{Netherlands}{-sep => 's*'}/; # Matches '1234 AB' and '1234AB'. $RE{zip}{Australia} Returns a pattern that recognizes Australian postal codes. Australian postal codes consist of four digits; the first two digits, which range from '10' to '97', indicate the state. Territories use '02' or '08' as starting digits; the leading zero is optional. '0909' is the only postal code starting with '09' (the leading zero is optional here as well) - this is the postal code for the Nothern Territory University). The (optional) country prefixes are AU (ISO country code) and AUS (CEPT code). Regexp::Common 2.107 and before used $RE{zip}{Australia}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The state or territory. $5 The last two digits. $RE{zip}{Belgium} Returns a pattern than recognizes Belgian postal codes. Belgian postal codes consist of 4 digits, of which the first indicates the province. The (optional) country prefixes are BE (ISO country code) and B (CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The digit indicating the province. $5 The last three digits of the postal code. $RE{zip}{Denmark} Returns a pattern that recognizes Danish postal codes. Danish postal codes consist of four numbers; the first digit (which cannot be 0), indicates the distribution region, the second the distribution district. The (optional) country prefix is DK, which is both the ISO country code and the CEPT code. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The digit indicating the distribution region. $5 The digit indicating the distribution district. $6 The last two digits of the postal code. $RE{zip}{France} Returns a pattern that recognizes French postal codes. French postal codes consist of five numbers; the first two numbers, which range from '01' to '98', indicate the department. The (optional) country prefixes are FR (ISO country code) and F (CEPT code). Regexp::Common 2.107 and before used $RE{zip}{French}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The department. $5 The last three digits. $RE{zip}{Germany} Returns a pattern that recognizes German postal codes. German postal codes consist of five numbers; the first number indicating the distribution zone, the second the distribution region, while the latter three indicate the distribution district and the postal town. The (optional) country prefixes are DE (ISO country code) and D (CEPT code). Regexp::Common 2.107 and before used $RE{zip}{German}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The distribution zone. $5 The distribution region. $6 The distribution district and postal town. $RE{zip}{Greenland} Returns a pattern that recognizes postal codes from Greenland. Greenland, being part of Denmark, uses Danish postal codes. All postal codes of Greenland start with 39. The (optional) country prefix is DK, which is both the ISO country code and the CEPT code. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 39, being the distribution region and distribution district for Greenland. $5 The last two digits of the postal code. $RE{zip}{Italy} Returns a pattern recognizing Italian postal codes. Italian postal codes consist of 5 digits. The first digit indicates the region, the second the province. The third digit is odd for province capitals, and even for the province itself. The fourth digit indicates the route, and the fifth a place on the route (0 for small places, alphabetically for the rest). The country prefix is either IT (the ISO country code), or I (the CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The region. $5 The province. $6 Capital or province. $7 The route. $8 The place on the route. $RE{zip}{Netherlands} Returns a pattern that recognizes Dutch postal codes. Dutch postal codes consist of 4 digits and 2 letters, separated by a space. The separator can be changed using the "{-sep}" option, as discussed above. The (optional) country prefix is NL, which is both the ISO country code and the CEPT code. Regexp::Common 2.107 and earlier used $RE{zip}{Dutch}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The digits part of the postal code. $5 The separator between the digits and the letters. $6 The letters part of the postal code. $RE{zip}{Norway} Returns a pattern that recognizes Norwegian postal codes. Norwegian postal codes consist of four digits. The country prefix is either NO (the ISO country code), or N (the CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $RE{zip}{Spain} Returns a pattern that recognizes Spanish postal codes. Spanish postal codes consist of 5 digits. The first 2 indicate one of Spains fifties provinces (in alphabetical order), starting with 00. The third digit indicates a main city or the main delivery rounds. The last two digits are the delivery area, secondary delivery route or a link to rural areas. The country prefix is either ES (the ISO country code), or E (the CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The two digits indicating the province. $5 The digit indicating the main city or main delivery route. $6 The digits indicating the delivery area, secondary delivery route or a link to rural areas. $RE{zip}{Switzerland} Returns a pattern that recognizes Swiss postal codes. Swiss postal codes consist of 4 digits. The first indicates the district, starting with 1. The second indicates the area, the third, the route, and the fourth the post office number. $RE{zip}{US}{-extended => [yes|no|allow]} Returns a pattern that recognizes US zip codes. US zip codes consist of 5 digits, with an optional 4 digit extension. By default, extensions are allowed, but not required. This can be influenced by the "-extended" option. If its argument starts with a "y", extensions are required; if the argument starts with a "n", extensions will not be recognized. If an extension is used, a dash is used to separate the main part from the extension, but this can be changed with the "-sep" option. The country prefix is either US (the ISO country code), or USA (the CEPT code). If "{-keep}" is being used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The first 5 digits of the postal code. $5 The first three digits of the postal code, indicating a sectional center or a large city. New in Regexp::Common 2.119. $6 The last 2 digits of the 5 digit part of the postal code, indicating a post office facility or delivery area. New in Regexp::Common 2.119. $7 The separator between the 5 digit part and the 4 digit part. Up to Regexp::Common 2.118, this used to be $5. $8 The 4 digit part of the postal code (if any). Up to Regexp::Common 2.118, this used to be $6. $9 The first two digits of the 4 digit part of the postal code, indicating a sector, or several blocks. New in Regexp::Common 2.119. $10 The last two digits of the 4 digit part of the postal code, indicating a segment or one side of a street. New in Regexp::Common 2.119. You need at least version 5.005_03 to be able to use US postal codes. Older versions contain a bug that let the pattern match invalid US postal codes. Questions o Can the 5 digit part of the zip code (in theory) start with 000? o Can the 5 digit part of the zip code (in theory) end with 00? o Can the 4 digit part of the zip code (in theory) start with 00? o Can the 4 digit part of the zip code (in theory) end with 00? SEE ALSO
Regexp::Common for a general description of how to use this interface. <http://www.columbia.edu/kermit/postal.html> Frank's compulsive guide to postal addresses. <http://www.upu.int/post_code/en/addressing_formats_guide.shtml> Postal addressing systems. <http://www.uni-koeln.de/~arcd2/33e.htm> Postal code information. <http://www.grcdi.nl/linkspc.htm> Links to Postcode Pages. <http://www1.auspost.com.au/postcodes/> Information about Australian postal codes. <http://hdusps.esecurecare.net/cgi-bin/hdusps.cfg/php/enduser/std_adp.php?p_faqid=1014> Information about US postal codes. <http://en.wikipedia.org/wiki/Postal_code> AUTHORS
Damian Conway (damian@conway.org) and Abigail (regexp-common@abigail.be). MAINTAINANCE
This package is maintained by Abigail (regexp-common@abigail.be). BUGS AND IRRITATIONS
Zip codes for most countries are missing. Send them in to regexp-common@abigail.be. LICENSE and COPYRIGHT This software is Copyright (c) 2001 - 2009, Damian Conway and Abigail. This module is free software, and maybe used under any of the following licenses: 1) The Perl Artistic License. See the file COPYRIGHT.AL. 2) The Perl Artistic License 2.0. See the file COPYRIGHT.AL2. 3) The BSD Licence. See the file COPYRIGHT.BSD. 4) The MIT Licence. See the file COPYRIGHT.MIT. perl v5.18.2 2013-03-08 Regexp::Common::zip(3)
All times are GMT -4. The time now is 09:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy