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

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

choqok

choqok(1)																 choqok(1)

NAME

       choqok - Blogging client for KDE4

SYNOPSIS

       choqok [ Generic-options ]

DESCRIPTION

       KDE  mono-blogging  client.   with  support for staying on System tray, and use system notifications to notify user about updates, and fair
       configurable.  The source code is in KDE svn server (playground section) and i will continue its development to make it fair stable and us-
       able  to add it to KDE Project.	Its current features: * Supporting User + His/Her Friends time-lines * Supporting @Reply time-lines * Sup-
       porting Multiple Accounts simultaneously.  * Supporting Identi.ca mono-blogging service (Using its Twitter compatible API)  *  Support  for
       send and receive direct messages * KWallet integration * Ability to make a quick tweet with global shortcuts (Ctrl+Meta+T) * Ability to no-
       tify user about new statuses text, with KNotification and Libnotify's notify-send command * Support for shortening urls with more  than	30
       characters * Support for configuring status lists appearance.  * and other configure options...	Project page: http://choqok.gnufolks.org/

OPTIONS

       --help Show help about options

       --help-qt
	      Show Qt specific options

       --help-kde
	      Show KDE specific options

       --help-all
	      Show all options

       --author
	      Show author information

       -v, --version
	      Show version information

       --license
	      Show license information

       --     Indicates end of options

COPYRIGHT

       This  manual  page  was	written by Anthony Mercatante <tonio@ubuntu.com> for the Ubuntu system (but may be used by others).  Permission is
       granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 3 or any  later  version
       published by the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

								    2009-01-23								 choqok(1)