Sponsored Content
Full Discussion: Converting the date format
Top Forums Shell Programming and Scripting Converting the date format Post 302520554 by ahamed101 on Sunday 8th of May 2011 04:17:02 AM
Old 05-08-2011
Try this, this should work if date is present in any column

Code:
awk -F"," '{for(i=1;i<NF;i++){t=match($i,/:/,_1);
if(t!=0){_2="date -d \""$i"\" +'%d-%h-%Y'"; _2|getline _d;$i=_d;print}} }' OFS="," inputfile

regards,
Ahamed
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Converting the File Creation Date to a new format

I need to capture a file's creation/modification date and time and convert this to a different format, whilst I can easily get the existing format from a ls -l | awk ' { print $......}' or a cut command I do not know how to convert it to a desired format? I should add that at present the ls -l... (1 Reply)
Discussion started by: barney_clough
1 Replies

2. Shell Programming and Scripting

converting date format

Hi Please anyone to help to write script to convert date to 'yyyy-mm-dd'(If column is date convert) because my file has large and lot of date colums. If file is small ,using awk command to achive. cat file1|awk 'BEGIN {FS=OFS='|'}... (7 Replies)
Discussion started by: mohan705
7 Replies

3. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

4. Shell Programming and Scripting

Converting windows format file to unix format using script

Hi, I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix. My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies

5. Shell Programming and Scripting

converting Date format

Dear Friends, We have date in output as MM/DD/YYYY format and I want to convert it in DD/MM/YYYY format. e.g. 12/31/2010 to 31/12/2010 We have checked forum for the solution but we are not getting matching query. Please guide us Thanks Anushree. (6 Replies)
Discussion started by: anushree.a
6 Replies

6. UNIX for Advanced & Expert Users

Converting the date format in a flat file

Hi All, I am new to this forum, could any one help me out in resolving the below issue. Input of the flat file contains several lines of text for example find below: 5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2 5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1... (0 Replies)
Discussion started by: av_sagar
0 Replies

7. Shell Programming and Scripting

Converting a date to friday date and finding Min/Max date

Dear all, I have 2 questions. I have a file with many rows which has date of the format YYYYMMDD. 1. I need to change the date to that weeks friday date(Ex: 20120716(monday) to 20120720). Satuday/Sunday has to be changed to next week friday date too. 2. After converting the date to... (10 Replies)
Discussion started by: 2001.arun
10 Replies

8. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

9. Shell Programming and Scripting

awk - problems by converting date-format

Hi i try to change the date-format from DD/MM/YYYY into MM/DD/YY. Input-Data: ... 31/12/2013,23:40,198.00,6.20,2,2,2,1,11580.0,222 31/12/2013,23:50,209.00,7.30,2,2,3,0,4380.0 01/01/2014,00:00,205.90,8.30,2,2,3,1,9360.0,223 ... Output-Data should be: ...... (7 Replies)
Discussion started by: IMPe
7 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 09:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy