Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to change date format in file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to change date format in file
# 1  
Old 10-08-2009
Power How to change date format in file
Hello!

I have a textfile that look like this:


Code:
"83d1:46:2b";"20091008190000";"Rögle BK - Skellefteå";"Swedish"
"d4c:46:21";"20091008190000";"Södertälje - Brynäs";"Swedish"
"d4b:46:2";"20091008190000";"HV 71 - Färjestad";"Swedish"
"838:46:b";"20091010160000";"Skellefteå - HV 71";"Swedish"
"a119:46:2b";"20091010160000";"Modo - Rögle BK";"Swedish"
"83d:46:2b";"20091010160000";"Timrå - Linköping";"Swedish"
etc
etc

And i want to change the date to epoch format, eg:

Code:
"838:46:2b";"1255021200";"Luleå - Djurgården";"Swedish"
"1139:46:2b";"1255021200";"Timrå - Modo";"Swedish"
"83d:46:2b";"1255021200";"Rögle BK - Skellefteå";"Swedish"
"d4c:46:2";"1255021200";"Södertälje - Brynäs";"Swedish"
"d4b:46:21";"1255021200";"HV 71 - Färjestad";"Swedish"
"838:46:b";"1255183200";"Skellefteå - HV 71";"Swedish"
"81b:46:2b";"1255183200";"Modo - Rögle BK";"Swedish" 
etc
etc

The system is SLES 11 x86

Is there an easy way to do this with a script?

Thanks in advice
Last edited by Franklin52; 10-08-2009 at 03:55 PM.. Reason: Please use code tags!
# 2  
Old 10-08-2009
With awk:

(n)awk version:
Code:
BEGIN{FS=OFS="\";\""}
{
  dte=substr($2,1,4) "-" substr($2,5,2) "-" substr($2,7,2) " " substr($2,9,2) ":" substr($2,11,2)
  sprintf("date -d'%s' +%%s", dte) | getline epoch
  $2=epoch
  print $0
}

GNU awk:
Code:
BEGIN{FS=OFS="\";\""}
{
  dte=substr($2,1,4) " " substr($2,5,2) " " substr($2,7,2) " " substr($2,9,2) " " substr($2,11,2) " " substr($2,13,2)
  $2=mktime(dte)
  print $0
}

# 3  
Old 10-08-2009
Code:
awk 'BEGIN{FS=OFS="\""}{"date -jf %Y%m%d%H%M%S "$4" +%s"| getline var;close("date -jf %Y%m%d%H%M%S "$4" +%s");$4=var}1' file

Work for me on FreeBSD Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Change date format in a file.

Hi all, I have a file as below, i would like the change the format of the time from "11/7/2019 20:12" to "2019-07-11 20:12:00" in the last coloumn. any awk solution on this. Input: 2,0,695016,1961612,497212,5800804,0,0,161,33,7605,12226,23,10,66,0,0,34,11/7/2019 20:10... (4 Replies)
Discussion started by: Raghuram717
4 Replies

2. Shell Programming and Scripting

Date format change in a csv file

Hi, We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script. Please let us know how can we achieve the same. (16 Replies)
Discussion started by: dholea
16 Replies

3. Shell Programming and Scripting

Need to change date format in a csv file using awk

Example: Input csv file 00245DLS,Sitel Ocala,12/31/2014,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel Ocala,12/31/2014,19:00,-1.00,-1.00,-1.00,-1.00 00245HB,Charlotte,01/01/2015,00:00,-1.00,-1.00,-1.00,0.00 Output csv file 00245DLS,Sitel Ocala,2014/12/31,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel... (8 Replies)
Discussion started by: adit
8 Replies

4. Shell Programming and Scripting

Date format change in UNIX .dat file

Hi, I need help to convert the date format in .DAT file in unix. I want to convert 10@@|SWIFT MT568 Extract@@|Apr 14 2014 5:47:52:563PM@@|Apr 14 2014 4:33:47:663PM@@||##| into 10@@|SWIFT MT568 Extract@@|04/14/2014/ 5:47:52:563PM@@|04/14/2014 4:33:47:663PM@@||##| Appreciate... (18 Replies)
Discussion started by: karthikengox
18 Replies

5. Shell Programming and Scripting

How to change the format of the date column in a flat file?

Hi, i have a flat file namely temp.txt with this data below ID|name|contact_date 101|Kay|2013-12-26 102|let|2013-12-26 I need to modify the date data in the flat file into MM/DD/YYYY HH24:MI:SS format let me know the code for this. Thank you! (5 Replies)
Discussion started by: srikanth_sagi
5 Replies

6. Shell Programming and Scripting

File date format how to change

Hi All, Below are the unix files taken by the help of ls -lrt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 13:33 sand.txt -rw-r--r-- 1 kbehera Domain Users 4 Jul 27 13:37 sand1.txt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 15:30 new_sand.txt -rw-r--r-- 1 kbehera Domain Users 0 Jul 27... (2 Replies)
Discussion started by: krupasindhu18
2 Replies

7. Shell Programming and Scripting

Date format change

Dear Friends, Need your help once again, I have a variable ( e.g. ${i}) whoch has date in MM/DD/YYYY (E.g. 12/31/2011) format. I want to change it to DD/MM/YYYY (e.g. 31/12/2011) format. Request you to guide me as we are unable to do the same. Thanks in advance Anu. (1 Reply)
Discussion started by: anushree.a
1 Replies

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

9. Shell Programming and Scripting

script to change the date format in a file

i have many files with date format of 6-9-2008 and i want a script that can change the format to 2008-06-09 Thanks (15 Replies)
Discussion started by: shehzad_m
15 Replies

10. UNIX for Dummies Questions & Answers

How to change it to the date format

Hi, I want to know how to change this string to date format 20061102122042 to 02-11-2006 12:20:42 or 02-Nov-2006 12:20:42 Please let me know at the earliest.Thanks in advance. Regards, Preetham R. (3 Replies)
Discussion started by: preethgideon
3 Replies
Login or Register to Ask a Question