Sponsored Content
Top Forums Shell Programming and Scripting How to change date format in file Post 302360287 by condmaster on Thursday 8th of October 2009 01:43:27 PM
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!
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
Lingua::Stem::Sv(3pm)					User Contributed Perl Documentation				     Lingua::Stem::Sv(3pm)

NAME
Lingua::Stem::Sv - Stemming algorithm for Swedish SYNOPSIS
use Lingua::Stem::Sv; my $stems = Lingua::Stem::Sv::stem({ -words => $word_list_reference, -locale => 'sv', -exceptions => $exceptions_hash, }); DESCRIPTION
This routine applies a stemming slgorithm to a passed anon array of Swedish words, returning the stemmed words as an anon array. It is a 'convienence' wrapper for 'Lingua::Stem::Snowball::Se' that provides a standardized interface and caching. CHANGES
1.01 2003.09.28 - Documentation fix 1.00 2003.04.05 - Initial release METHODS
stem({ -words => @words, -locale => 'sv', -exceptions => \%exceptions }); Stems a list of passed words using the rules of Swedish. Returns an anonymous array reference to the stemmed words. Example: my $stemmed_words = Lingua::Stem::Sv::stem({ -words => @words, -locale => 'sv', -exceptions => \%exceptions, }); stem_caching({ -level => 0|1|2 }); Sets the level of stem caching. '0' means 'no caching'. This is the default level. '1' means 'cache per run'. This caches stemming results during a single call to 'stem'. '2' means 'cache indefinitely'. This caches stemming results until either the process exits or the 'clear_stem_cache' method is called. clear_stem_cache; Clears the cache of stemmed words NOTES
This code is a wrapper around Lingua::Stem::Snowball::Sv written by Ask Solem Hoel, <ask@unixmonks.net> SEE ALSO
Lingua::Stem Lingua::Stem::Snowball::Sv AUTHOR
Integration in Lingua::Stem by Benjamin Franz, FreeRun Technologies, snowhare@nihongo.org or http://www.nihongo.org/snowhare/ COPYRIGHT
Benjamin Franz, FreeRun Technologies This code is freely available under the same terms as Perl. BUGS
TODO
perl v5.10.1 2007-10-23 Lingua::Stem::Sv(3pm)
All times are GMT -4. The time now is 11:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy