Sponsored Content
Top Forums Shell Programming and Scripting How to sort a field in a file having date values Post 302202089 by risshanth on Wednesday 4th of June 2008 03:56:06 AM
Old 06-04-2008
I have used a small file for testing

A line in the file looks like thsi
deepak|55445|12-02-2008|alappuzha
 

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... (4 Replies)
Discussion started by: shivaastrogun
4 Replies

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... (5 Replies)
Discussion started by: sweta_doshi
5 Replies

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|... (3 Replies)
Discussion started by: jojo123
3 Replies

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... (6 Replies)
Discussion started by: csierra
6 Replies

5. Shell Programming and Scripting

Sorting Date Field with Sort -k :/

SOLVED : (17 Replies)
Discussion started by: Glitch100
17 Replies

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 ... (3 Replies)
Discussion started by: rveri
3 Replies

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... (3 Replies)
Discussion started by: dhruuv369
3 Replies

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... (2 Replies)
Discussion started by: Amit Joshi
2 Replies

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... (5 Replies)
Discussion started by: cmccabe
5 Replies
SWISS::Stars::EV(3pm)					User Contributed Perl Documentation				     SWISS::Stars::EV(3pm)

   new
   fromText
   toText
   sort
   addEvidence($category, $type, $initials, $attributes [, $date])
	Title:	  addEvidence

	Usage:	  $evidenceTag = $entry->Stars->EV->addEvidence($category,
								$type,
								$initials,
								$attributes
								[, $date])

	Function: adds the evidence to the EV block if it does not yet exist
		  or returns the correct evidence tag if the evidence already exists,
		  possibly with a different date.

	Args:	 $category: the evidence category. Currently one of 'A', 'C', 'I','P'.
		 $type: the evidence type
		 $initials: The initals of the person doing the update.
			    For programs this should be '-'.
		 $attributes: the attributes of the evidence
		 $date: optional. If present, it must be in standard SWISS-PROT
			date format. If not present the current date will be used.

	Returns: The correct evidence tag.

   updateEvidence($category, $type, $initials, $attributes [, $date])
	Title:	  updateEvidence

	Usage:	  $evidenceTag = $entry->Stars->EV->updateEvidence($category,
								   $type,
								   $initials,
								   $attributes
								   [, $date])

	Function: updates the evidence to the EV block to $date or inserts it
		  if it does not yet exist.

	Args:	 $category: the evidence category. Currently one of 'A', 'C', 'I','P'.
		 $type: the evidence type
		 $initials: The initals of the person doing the update.
			    For programs this should be '-'.
		 $attributes: the attributes of the evidence
		 $date: optional. If present, it must be in standard SWISS-PROT
			date format. If not present the current date will be used.

	Returns: The correct evidence tag.

Name
       SWISS::Stars::EV.pm

Description
       SWISS/Stars/EV.pm represents the evidence section within an SWISS-PROT + TrEMBL entry. See
       http://www3.ebi.ac.uk/~sp/intern/projects/evidenceTags/index.html

       For a usage example, see evTest.pl in the Swissknife package.

Inherits from SWISS::ListBase.pm
Attributes
       "list" Each element of the list describes one evidence, itself represented as an array.

perl v5.10.1							    2006-01-26						     SWISS::Stars::EV(3pm)
All times are GMT -4. The time now is 08:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy