Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sort csv file
Top Forums Shell Programming and Scripting sort csv file Post 302165820 by KevinADC on Saturday 9th of February 2008 04:34:32 AM
Old 02-09-2008
Well, hopefully I did this for more than my own amusement:

Code:
#!/usr/bin/perl
use warnings;
use strict;
my @months_numeric = qw(01 02 03 04 05 06 07 08 09 10 11 12);
my @months_alphas  = qw(jan feb mar apr may jun jul aug sep oct nov dec);
my %months;
@months{@months_alphas} = @months_numeric;
open (my $in , '<', 'path/to/celebs.csv') or die "$!";
my @sorted = map {$_->[0]}
             sort{$a->[1] cmp $b->[1]}
             map {chomp;
                  my $bd = (split(","))[2];
                  my ($d,$m,$y) = split("-",$bd);
                  $d = $d<10 ? "0$d" : $d;
                  [$_,"$y$months{$m}$d"]} <$in>;
close $in;
print "$_\n" for @sorted;

Assumes the months are all represented by three characters and are always all lower-case letters.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort the csv file

hello , the content of a csv file is looking like this... vah1 , imk4 , LDAP Secure. vah1 , fmk1 , Not able to SSH vah1 , fk1 ,Not able to SSH vah1 , imk1 , LDAP Secure. vah1 , imk3 , Un-Secured vah1 , fmk1 , LDAP Secure. vah1 , fk1 , LDAP Secure. vah1 , fmk1 , LDAP Secure. vah1 ,... (2 Replies)
Discussion started by: nagendramv
2 Replies

2. Shell Programming and Scripting

How to sort columns in excel(csv) file

i want sort columns with headers based on another file headers file1 eg: i'm having an empty file with only coumn names like lastname firstname title expirydate stlcno status etc... another file with same column names and some other as well but in different order... file2 eg:firstname... (2 Replies)
Discussion started by: Man83Nagesh
2 Replies

3. UNIX for Dummies Questions & Answers

Sort and join all .csv files

Hi , I have a dump of .csv files in a folder, I need to sort all files by the first 3 columns and merge them all in one big csv file. I am using a cat command to join them, but how can i sort before appending all the files as one big file, Regards, Shruthi (4 Replies)
Discussion started by: shruthidwh
4 Replies

4. Shell Programming and Scripting

Sort csv file

Hello, I am facing the following problem: I have a file in csv format. So several records where data fields are separated by comma ',' The lenght of the fields is variable, as well as the number of fields per record. But there are at least 7 fields per record. I need to sort the file based... (1 Reply)
Discussion started by: BSF
1 Replies

5. Shell Programming and Scripting

Sort on mm/dd/yyyy csv

I have the following csv data that I would like to sort on the 4th field by date from oldest to newest. data: ,,,02/06/2012,Carry H,Add,Add,Sys_RTH,111.222.333.777 4/7/12,,,03/03/2013,Parry H,Add,Add,Sys_RTH,111.222.333.776 ,,,12/06/2012,Harry H,Add,Add,Sys_RTH,111.222.333.778... (3 Replies)
Discussion started by: wbrunc
3 Replies

6. UNIX for Dummies Questions & Answers

Sort csv file by duplicated column value

hello, I have a large file (about 1gb) that is in a file similar to the following: I want to make it so that I can put all the duplicates where column 3 (delimited by the commas) are shown on top. Meaning all people with the same age are listed at the top. The command I used was ... (3 Replies)
Discussion started by: jl487
3 Replies

7. Shell Programming and Scripting

Sort and list values from CSV

I have a CSV with below values name,city,2,country name,city,15,country abc,wq,10,afdfd, qeqe,ewqre,1,wqew I need to sort them in ascending order based on the value of column 3 and then , pick the rows with values less than 10 and be able to display the columns in that row. Can anyone... (11 Replies)
Discussion started by: Nevergivup
11 Replies

8. UNIX for Beginners Questions & Answers

How to sort a column in excel/csv file?

I have to sort the 4th column of an excel/csv file. I tried the following command sort -u --field-separator=, --numeric-sort -k 2 -n dinesh.csv > test.csv But, it's not working. Moreover, I have to do the same for more than 30 excel/csv file. So please help me to do the same. (6 Replies)
Discussion started by: dineshkumarsrk
6 Replies

9. UNIX for Beginners Questions & Answers

How to align/sort the column pairs of an csv file, based on keyword word specified in another file?

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 MOJAVE

datetime::locale::kl_gl

DateTime::Locale::kl_GL(3)				User Contributed Perl Documentation				DateTime::Locale::kl_GL(3)

NAME

       DateTime::Locale::kl_GL

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'kl_GL' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Kalaallisut Greenland.

DATA

       This locale inherits from the DateTime::Locale::kl locale.

       It contains the following data.

   Days
       Wide (format)

	 ataasinngorneq
	 marlunngorneq
	 pingasunngorneq
	 sisamanngorneq
	 tallimanngorneq
	 arfininngorneq
	 sabaat

       Abbreviated (format)

	 ata
	 mar
	 pin
	 sis
	 tal
	 arf
	 sab

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 ataasinngorneq
	 marlunngorneq
	 pingasunngorneq
	 sisamanngorneq
	 tallimanngorneq
	 arfininngorneq
	 sabaat

       Abbreviated (stand-alone)

	 ata
	 mar
	 pin
	 sis
	 tal
	 arf
	 sab

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 januari
	 februari
	 martsi
	 aprili
	 maji
	 juni
	 juli
	 augustusi
	 septemberi
	 oktoberi
	 novemberi
	 decemberi

       Abbreviated (format)

	 jan
	 feb
	 mar
	 apr
	 maj
	 jun
	 jul
	 aug
	 sep
	 okt
	 nov
	 dec

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 januari
	 februari
	 martsi
	 aprili
	 maji
	 juni
	 juli
	 augustusi
	 septemberi
	 oktoberi
	 novemberi
	 decemberi

       Abbreviated (stand-alone)

	 jan
	 feb
	 mar
	 apr
	 maj
	 jun
	 jul
	 aug
	 sep
	 okt
	 nov
	 dec

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 BCE
	 CE

       Narrow

	 BCE
	 CE

   Date Formats
       Full

	  2008-02-05T18:30:30 = marlunngorneq 05 februari 2008
	  1995-12-22T09:05:02 = tallimanngorneq 22 decemberi 1995
	 -0010-09-15T04:44:23 = arfininngorneq 15 septemberi -10

       Long

	  2008-02-05T18:30:30 = 05 februari 2008
	  1995-12-22T09:05:02 = 22 decemberi 1995
	 -0010-09-15T04:44:23 = 15 septemberi -10

       Medium

	  2008-02-05T18:30:30 = feb 05, 2008
	  1995-12-22T09:05:02 = dec 22, 1995
	 -0010-09-15T04:44:23 = sep 15, -10

       Short

	  2008-02-05T18:30:30 = 05/02/08
	  1995-12-22T09:05:02 = 22/12/95
	 -0010-09-15T04:44:23 = 15/09/-10

       Default

	  2008-02-05T18:30:30 = feb 05, 2008
	  1995-12-22T09:05:02 = dec 22, 1995
	 -0010-09-15T04:44:23 = sep 15, -10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 6:30:30 PM UTC
	  1995-12-22T09:05:02 = 9:05:02 AM UTC
	 -0010-09-15T04:44:23 = 4:44:23 AM UTC

       Long

	  2008-02-05T18:30:30 = 6:30:30 PM UTC
	  1995-12-22T09:05:02 = 9:05:02 AM UTC
	 -0010-09-15T04:44:23 = 4:44:23 AM UTC

       Medium

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

       Short

	  2008-02-05T18:30:30 = 6:30 PM
	  1995-12-22T09:05:02 = 9:05 AM
	 -0010-09-15T04:44:23 = 4:44 AM

       Default

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = marlunngorneq 05 februari 2008 6:30:30 PM UTC
	  1995-12-22T09:05:02 = tallimanngorneq 22 decemberi 1995 9:05:02 AM UTC
	 -0010-09-15T04:44:23 = arfininngorneq 15 septemberi -10 4:44:23 AM UTC

       Long

	  2008-02-05T18:30:30 = 05 februari 2008 6:30:30 PM UTC
	  1995-12-22T09:05:02 = 22 decemberi 1995 9:05:02 AM UTC
	 -0010-09-15T04:44:23 = 15 septemberi -10 4:44:23 AM UTC

       Medium

	  2008-02-05T18:30:30 = feb 05, 2008 6:30:30 PM
	  1995-12-22T09:05:02 = dec 22, 1995 9:05:02 AM
	 -0010-09-15T04:44:23 = sep 15, -10 4:44:23 AM

       Short

	  2008-02-05T18:30:30 = 05/02/08 6:30 PM
	  1995-12-22T09:05:02 = 22/12/95 9:05 AM
	 -0010-09-15T04:44:23 = 15/09/-10 4:44 AM

       Default

	  2008-02-05T18:30:30 = feb 05, 2008 6:30:30 PM
	  1995-12-22T09:05:02 = dec 22, 1995 9:05:02 AM
	 -0010-09-15T04:44:23 = sep 15, -10 4:44:23 AM

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 mar
	  1995-12-22T09:05:02 = 22 tal
	 -0010-09-15T04:44:23 = 15 arf

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 PM
	  1995-12-22T09:05:02 = 9:05 AM
	 -0010-09-15T04:44:23 = 4:44 AM

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = mar, 2-5
	  1995-12-22T09:05:02 = tal, 12-22
	 -0010-09-15T04:44:23 = arf, 9-15

       MMdd (dd/MM)

	  2008-02-05T18:30:30 = 05/02
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/09

       MMM (LLL)

	  2008-02-05T18:30:30 = feb
	  1995-12-22T09:05:02 = dec
	 -0010-09-15T04:44:23 = sep

       MMMd (MMM d)

	  2008-02-05T18:30:30 = feb 5
	  1995-12-22T09:05:02 = dec 22
	 -0010-09-15T04:44:23 = sep 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = mar feb 5
	  1995-12-22T09:05:02 = tal dec 22
	 -0010-09-15T04:44:23 = arf sep 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = februari 5
	  1995-12-22T09:05:02 = decemberi 22
	 -0010-09-15T04:44:23 = septemberi 15

       MMMMdd (dd MMMM)

	  2008-02-05T18:30:30 = 05 februari
	  1995-12-22T09:05:02 = 22 decemberi
	 -0010-09-15T04:44:23 = 15 septemberi

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = mar februari 5
	  1995-12-22T09:05:02 = tal decemberi 22
	 -0010-09-15T04:44:23 = arf septemberi 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = mar, 2008-2-5
	  1995-12-22T09:05:02 = tal, 1995-12-22
	 -0010-09-15T04:44:23 = arf, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 feb
	  1995-12-22T09:05:02 = 1995 dec
	 -0010-09-15T04:44:23 = -10 sep

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = mar, 2008 feb 5
	  1995-12-22T09:05:02 = tal, 1995 dec 22
	 -0010-09-15T04:44:23 = arf, -10 sep 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 februari
	  1995-12-22T09:05:02 = 1995 decemberi
	 -0010-09-15T04:44:23 = -10 septemberi

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyMM (MM/yy)

	  2008-02-05T18:30:30 = 02/08
	  1995-12-22T09:05:02 = 12/95
	 -0010-09-15T04:44:23 = 09/-10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = februari 2008
	  1995-12-22T09:05:02 = decemberi 1995
	 -0010-09-15T04:44:23 = septemberi -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       sabaat

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						DateTime::Locale::kl_GL(3)
All times are GMT -4. The time now is 12:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy