How to sort a field in a file having date values Post: 302202089

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Sort files on date field

:cool: Hi all, I have a pecular issue in sorting these files in Solaris environment. All the below files are modified on November 4th, but I want to sort these files as per date column (eg: 01May07_1623 = ddmmmyy_hhmm) Nov 4 18:27 SONYELEC00.GI22973.01May07_1623.gpg Nov 4 18:27...

2. Shell Programming and Scripting

Sort two columns in a field, one of them being a date

Hi, I have a set of columns in a csv file, my first row being an integer and 2nd being a date. I want to first sort it using the first column and then by the second. for e.g. i have , 1234,09/05/2009,hi 5678,01/01/2008,hi 1234,11/03/2006,hello 5678,28/07/2010,hello i tried this...

3. Shell Programming and Scripting

how to sort date in decimal values uptp two digits

Hi all, there is a data in a file wich loks likes 00:00:49|24.48| 00:01:49|22.83| 00:02:49|22.07| 00:03:49|20.72| 00:04:49|21.28| 00:05:49|21.22| 00:06:49|21.38| 00:07:49|20.93| 00:08:49|21.27| 00:09:49|20.65| 00:10:49|19.42| 00:11:49|21.93| 00:12:49|20.62| 00:13:49|20.23|...

4. UNIX for Dummies Questions & Answers

Sort field by date mm/dd/yyyy

Hello Group, I would like to sort the below file by date (first year then month and day) and I used the following command but it does not work sort -n -t"/" -k3 -k1 -k2 "sample original file" 12/28/2009,1.0353 12/31/2009,1.0357 12/30/2009,1.0364 12/29/2009,1.0366 12/24/2009,1.0386...

5. Shell Programming and Scripting

Sorting Date Field with Sort -k :/

SOLVED :

6. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

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 ...

7. Linux

How do I format a Date field of a .CSV file with multiple commas in a string field?

I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below: column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10 "12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in...

8. AIX

Sort by date field in AIX

I wanted to sort the below data on 4th field(comma seperator) based on month and date and time on AIX OS. Input data: 3,AJ,30 Jul 06:30,30 Jul 06:30 5,AJ,30 Jul 06:30,30 Jul 06:49 10,AJ,30 Jul 06:30,02 Jan 05:41 4,AJ,30 Jul 06:30,30 Jul 06:36 2,AJ,30 Jul 06:30,28 Jul 06:45 9,AJ,30 Jul...

9. Shell Programming and Scripting

Sort file by field 1 that has text as well as a number

I am using the below awk that results in the below output: awk '{k=$1 OFS $2; s+=$4; c++} END{for(i in s) print i, s/c}' input.txt > output.txt output.txt chr20:43625799-43625957 STK4:exon.6;STK4:exon.7 310.703 chr20:36770455-36770611 TGM2:exon.6;TGM2:exon.7 614.756...

LEARN ABOUT DEBIAN

pod2test

POD2TEST(1p)						User Contributed Perl Documentation					      POD2TEST(1p)

NAME

       pod2test - Convert embedded tests and code examples to .t files

SYNOPSIS

	 pod2test [-Mmodule] [input [output]]

DESCRIPTION

       pod2test is a front-end for Pod::Tests (formerly Test::Inline 1).  It generates TAP-compatible .t testing scripts from embedded tests and
       code examples.

       If output is not specified, the resulting .t file will go to STDOUT.  Otherwise, it will go to the given output file.  If input is not
       given, it will draw from STDIN.

       If the given file contains no tests or code examples, no output will be given, no output file will be created and pod2test will exit with
       1.

       The Test::More module is made available to the testing blocks using the 'no_plan' feature.  Any further modules which should be used are
       specified with -M. UNIMPLEMENTED

BUGS and CAVEATS
       This is a very simple rough cut.  It only does very rudimentary tests on the examples.

SUPPORT

       This script has been superceded by "inline2test" from the newer Test::Inline 2. Most testing code that currently works with "pod2test"
       should continue to work with the new version.

       The most notable exceptions are "=for begin" and "=for end", which are deprecated in the newer version.

       After upgrading Test::Inline, Pod::Tests and "pod2test" were split out to provide a compatibility package for legacy code.

       "pod2test" will stay in CPAN, but should remain unchanged indefinately, with the exception of any minor bugs that will require squishing.

       Bugs in this dist should be reported via the following URL. Feature requests should not be submitted, as further development is now
       occuring in Test::Inline.

       http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Pod-Tests <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Pod-Tests>

AUTHOR

       Michael G Schwern <schwern@pobox.com>

       Adam Kennedy <adamk@cpan.org>

SEE ALSO

       Pod::Tests, Test::Inline

COPYRIGHT

       Copyright 2005 - 2008 Adam Kennedy.

       Copyright 2001 - 2003 Michael G Schwern.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       The full text of the license can be found in the LICENSE file included with this module.

perl v5.12.4							    2008-07-13							      POD2TEST(1p)