Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date format change in a csv file
Top Forums Shell Programming and Scripting Date format change in a csv file Post 302948829 by Smiling Dragon on Thursday 2nd of July 2015 07:17:14 PM
Old 07-02-2015
I'm going to assume this is some sort of *nix environment due to the requirement for it to be in shell.
The date command can do this for you:
Code:
date -d "$yourolddateformat" +"%d/%b/%Y %H:%M:%S"

If you need to do this via shell (I'll use bourne as it's the only shell you have on all *nix's), you'll just need to do a little lookup:
Code:
month=`echo "$yourolddateformat" | cut -d '/' -f 1`
day=`echo "$yourolddateformat" | cut -d '/' -f 2`
therest=`echo "$yourolddateformat" | cut -d '/' -f 3`
case $month in
  01)
    monthname="Jan"
    ;;
  02)
    monthname="Feb"
    ;;
  03)
    monthname="Mar"
    ;;
  04)
    monthname="Apr"
    ;;
  05)
    monthname="May"
    ;;
  06)
    monthname="Jun"
    ;;
  07)
    monthname="Jul"
    ;;
  08)
    monthname="Aug"
    ;;
  09)
    monthname="Sep"
    ;;
  10)
    monthname="Oct"
    ;;
  11)
    monthname="Nov"
    ;;
  12)
    monthname="Dec"
    ;;
  *)
    exit 1
    ;;
esac
echo "${day}/${monthname}/$therest"

The date command is tested, the script is not - some debug may be required.
Some editing will be required to make it fit you larger needs of course too but the core should be enough to get you 95% there.
 

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

Format a date in a csv file

So I have a csv file where the 3rd field is a date string in the format yyyy-mm-dd. I need to change it to mm/dd/yyyy. So each line in the csv file looks like: StringData,StringData,2009-02-17,12.345,StringData StringData,StringData,2009-02-16,65.789,StringData Any idea how I can keep... (5 Replies)
Discussion started by: rpiller
5 Replies

3. Shell Programming and Scripting

How to change date format in file

Hello! I have a textfile that look like this: "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"... (2 Replies)
Discussion started by: condmaster
2 Replies

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

5. Shell Programming and Scripting

Changing date format in CSV file

I have a CSV file with a date format like this; 11/19/2012 17:37:00,1.372,121.6 11/19/2012 17:38:00,0.743,121.6 Want to change the time stamp to seconds after 1970 so I can get the data in rrdtool. For anyone interested, this is data from a TED5000 unit and is Kwatts and volts. Needs to... (3 Replies)
Discussion started by: ottsm
3 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

Datestamp format 2nd change in csv file (awk or sed)

I have a csv file formatted like this: 2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07and I'm trying to change it to MM/DD/YYYY HH:MM for both occurances. I have got this: awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csvThis... (6 Replies)
Discussion started by: say170
6 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

Change date format in am/pm in csv files using UNIX

Hi All, I'm new to forum good to hear all. I stuck in converting date format in csv file using unix csv file contains as below ,750,0000000000000000GCJR, ,06/22/2016 14:48:44 I want to convert into as below ,750,0000000000000000GCJR, ,06/22/2016 02:48:44 PM Please reply asap..... (22 Replies)
Discussion started by: Raghureds
22 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

LEARN ABOUT DEBIAN

data::formvalidator::constraints::dates

Data::FormValidator::Constraints::Dates(3pm)		User Contributed Perl Documentation	      Data::FormValidator::Constraints::Dates(3pm)

NAME

       Data::FormValidator::Constraints::Dates - Validate Dates and Times

SYNOPSIS

	   use Data::FormValidator::Constraints::Dates qw(date_and_time);

	   # In a DFV profile...
	   constraint_methods => {
	       # 'pp' denotes AM|PM for 12 hour representation
	       my_time_field => date_and_time('MM/DD/YYYY hh:mm:ss pp'),
	   }

DESCRIPTION

   date_and_time
       Note: This is a new module is a new addition to Data::FormValidator and is should be considered "Beta".

       This constraint creates a regular expression based on the format string passed in to validate your date against. It understands the
       following symbols:

	   Y   year  (numeric)
	   M   month (numeric)
	   D   day   (numeric)
	   h   hour
	   m   minute
	   s   second
	   p   AM|PM

       Other parts of the string become part of the regular expression, so you can do perlish things like this to create more complex expressions:

	   'MM?/DD?/YYYY|YYYY-MM?-DD?'

       Internally Date::Calc is used to test the functions.

BACKWARDS COMPATIBILITY

       This older, more awkward interface is supported:

	   # In a Data::FormValidator Profile:
	   validator_packages => [qw(Data::FormValidator::Constraints::Dates)],
	   constraints => {
	       date_and_time_field	 => {
		   constraint_method => 'date_and_time',
		   params=>['MM/DD/YYYY hh:mm:ss pp'], # 'pp' denotes AM|PM for 12 hour representation
	       },
	   }

SEE ALSO

       o   Data::FormValidator

       o   Data::FormValidator::Constraints::DateTime  - This alternative features returning dates as DateTime objects and validating against the
	   date formats required for the MySQL and PostgreSQL databases.

AUTHOR

       Mark Stosberg, <mark@summersault.com>

       Featuring clever code by Jan Krynicky.

COPYRIGHT AND LICENSE

       Copyright 2003-2005 by Mark Stosberg

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2011-11-25			      Data::FormValidator::Constraints::Dates(3pm)
All times are GMT -4. The time now is 11:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy