Sponsored Content
Top Forums Shell Programming and Scripting [Solved] Sorting by several fields Post 302494107 by rubber08 on Saturday 5th of February 2011 05:40:51 AM
Old 02-05-2011
[Solved] Sorting by several fields

Hello,
I have a file with information separated by ";" like this:
Code:
ABC;20110126000008;00-10-95-29-17-C6;2;37190292
ABC;20110126000008;00-10-95-29-17-C6;1;53140866
ABC;20110126000008;00-10-05-01-11-38;2;11182251
ABC;20110126000008;00-10-05-01-11-38;1;25952816
ABC;20110126000009;00-10-95-29-17-C6;2;37190292
ABC;20110126000009;00-10-95-29-17-C6;1;53140866

and i would like to be ordered by fields 3, 2 and 4 like:
Code:
ABC;20110126000008;00-10-05-01-11-38;1;25952816
ABC;20110126000008;00-10-05-01-11-38;2;11182251
ABC;20110126000008;00-10-95-29-17-C6;1;53140866
ABC;20110126000008;00-10-95-29-17-C6;2;37190292
ABC;20110126000009;00-10-95-29-17-C6;1;53140866
ABC;20110126000009;00-10-95-29-17-C6;2;37190292

Thanks,

bye

Last edited by Scott; 02-05-2011 at 06:46 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sorting Compressed Fields

Are any of you guys aware of any problems when trying to sort compressed fields? Why I uncompress the file I am trying to sort, I have no problem sorting but when I try to sort compressed fields it doesnt work properly. I need to be able to sort these compressed fields. Any explanation why? (1 Reply)
Discussion started by: ndoggy020
1 Replies

2. UNIX for Dummies Questions & Answers

Sorting 2 positional fields

Hi Friends, I've a large datafile, I've to sort the entire records of this file based on the positions. For ex: ccc112IVEAGH VETERINARY SERVICES cca110SHOOTER PROPERTY SERVICES bbb111JUNIOR GOLF ACADEMY LIMITED aaa110AULD PROPERTIES T/A R&J AULD ccb111LISBURN FUELS aac112P & MRS C... (1 Reply)
Discussion started by: ganapati
1 Replies

3. UNIX for Dummies Questions & Answers

sorting fields of a line

Hi all, I have a file that looks like this... ########## 1zz2_15-43 1ouy_0-13-35 1.12619901947 2gfs_41-7 1yqj_3 0.793602121208 1bl7_11-3 1wbo_1-3-4 0.791065168287 1ywr_16-3 2ghl_22 0.956896171134 2exc_11-35 1pmq_13-15-87 0.597677672501 2bal_25-7 1ouk_17-19-21-228-58 0.668388304836... (6 Replies)
Discussion started by: Digby
6 Replies

4. Shell Programming and Scripting

sorting(both Ascending & Descending) files based on multiple fields

Hi All, I am encountered with a problem while sorting a file based on multiple columns . I need to sort like: (field2,ascending) , (field3,ascending) ,(field8,descending) , (field7,ascending),(field13,ascending). So far i was sorting only in ascending order but here i need to use one... (1 Reply)
Discussion started by: apjneeraj
1 Replies

5. Shell Programming and Scripting

AWK multiple line fields sorting

I have a bash script which takes a log file with each record separated by a #. The records have multiple fields but field $1 is always the date and time. When the script is run it prints the record just fine from oldest to newest. I need to have records print out from newest first. Here is the... (7 Replies)
Discussion started by: numele
7 Replies

6. Shell Programming and Scripting

[SOLVED] Sorting into new files based on column

Hi, I have the following file, I need to sort it based on a column and write to different output files based on this column request_guid iso_country_cd address_data response_time 32895901-d17f-414c-ac93-3e7e0f5ec240 AND BaseName:CATALUNYA; HouseNumber:1; ISOCountryCode:AND;... (1 Reply)
Discussion started by: ramky79
1 Replies

7. Shell Programming and Scripting

[SOLVED] Sorting file and get everything on same line on condition

Good afternoon! I am a perl newbie. I hope you will be patient with me. I have a script that needs to be written in perl. I can't do it in awk or shell scripting. Here is the script: #!/usr/bin/perl use POSIX qw(strftime); use FileHandle; use Getopt::Long; use IO::Handle;... (0 Replies)
Discussion started by: brianjb
0 Replies

8. Shell Programming and Scripting

ip 2 country sorting[solved]

Dear folks. I have list of ip address from different country, i would like check from script this ip address belong to which country, please suggest any command, i have more than 200 ip address so i need to do it via script. Script will show me country code and its City if possible? ... (0 Replies)
Discussion started by: learnbash
0 Replies

9. UNIX for Dummies Questions & Answers

[Solved] Help correcting file with differing number of fields

Hi all, I have a tab separated file, and one of the fields is sub-delimited by colon. The problem is there can be zero to 4 colons within this field. When I try to change colons to tabs the result is a file with a differing number of fields. I want to go from: a:b:c:d:e a:b:c a:b:c:d:e a... (4 Replies)
Discussion started by: torchij
4 Replies

10. UNIX for Dummies Questions & Answers

Sorting on fields for last date

Hi all, I have a file with a list of rpm's that have different dates. I am trying to just grab the latest rpm and install date, and discard the rest. The file has 1000's of entries all with different names and dates. I have tried sort -k on the file and I am not grabbing the info, ... (4 Replies)
Discussion started by: gartie
4 Replies
FS_LSMOUNT(1)						       AFS Command Reference						     FS_LSMOUNT(1)

NAME
       fs_lsmount - Reports the volume for which a directory is the mount point.

SYNOPSIS
       fs lsmount -dir <directory>+ [-help]

       fs ls -d <directory>+ [-h]

DESCRIPTION
       The fs lsmount command reports the volume for which each specified directory is a mount point, or indicates with an error message that a
       directory is not a mount point or is not in AFS.

       To create a mount point, use the fs mkmount command. To remove one, use the fs rmmount command.

OPTIONS
       -dir <directory>+
	   Names the directory that serves as a mount point for a volume. The last element in the pathname provided must be an actual name, not a
	   shorthand notation such as one or two periods ("." or "..").

       -help
	   Prints the online help for this command. All other valid options are ignored.

OUTPUT
       If the specified directory is a mount point, the output is of the following form:

	  '<directory>' is a mount point for volume '<volume name>'

       where

       o   A number sign ("#") precedes the <volume name> string for a regular mount point.

       o   A percent sign ("%") precedes the <volume name> string for a read/write mount point.

       o   A cell name and colon (":") follow the number or percent sign and precede the <volume name> string for a cellular mount point.

       The fs mkmount reference page explains how the Cache Manager interprets each of the three types of mount points.

       If the directory is a symbolic link to a mount point, the output is of the form:

	  '<directory>' is a symbolic link, leading to a mount point for volume
	  '<volume name>'

       If the directory is not a mount point or is not in AFS, the output reads:

	  '<directory>' is not a mount point.

       If the output is garbled, it is possible that the mount point has become corrupted in the local AFS client cache. Use the fs flushmount
       command to discard it, which forces the Cache Manager to refetch the mount point.

EXAMPLES
       The following example shows the mount point for the home directory of user "smith":

	  % fs lsmount /afs/abc.com/usr/smith
	  '/afs/abc.com/usr/smith' is a mount point for volume '#user.smith'

       The following example shows both the regular and read/write mount points for the ABC Corporation cell's "root.cell" volume.

	  % fs lsmount /afs/abc.com
	  '/afs/abc.com' is a mount point for volume '#root.cell'

	  % fs lsmount /afs/.abc.com
	  '/afs/.abc.com' is a mount point for volume '%root.cell'

       The following example shows a cellular mount point: the State University cell's "root.cell" volume as mounted in the ABC Corporation cell's
       tree.

	  % fs lsmount /afs/stateu.edu
	  '/afs/stateu.edu' is a mount point for volume '#stateu.edu:root.cell'

PRIVILEGE REQUIRED
       The issuer must have the "l" (lookup) permission on the ACL of the root directory of the volume that houses the file or directory named by
       the -dir argument, and on the ACL of each directory that precedes it in the pathname.

SEE ALSO
       fs_flushmount(1), fs_mkmount(1), fs_rmmount(1)

COPYRIGHT
       IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.

       This documentation is covered by the IBM Public License Version 1.0.  It was converted from HTML to POD by software written by Chas
       Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.

OpenAFS 							    2012-03-26							     FS_LSMOUNT(1)
All times are GMT -4. The time now is 10:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy