01-24-2013
awk - change date format
I have below date format in a CSV file. (dd/mm/yyyy)
Ex Input:
9/8/2013
Need to convert it into below format (yyyymmdd ) and redirect to new file.
Ex Output:
20130809
How do I use awk here to change the format and if leading 0 (zero) is not then add it.
Please help. Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to chnage the date format from the file format like below to
WT;T15D;0000007208;;20080401;3;0;0;3;;B;ZZZZZZ;
WT;T25D;0000007208;;20080401;6;0;0;6;;B;ZZZZZZ;
WT;T5D;0000007208;;20080401;123;0;0;123;;B;ZZZZZZ;
to
WT;T15D;0000007208;;04/01/200804;3;0;0;3;;B;ZZZZZZ;... (2 Replies)
Discussion started by: svenkatareddy
2 Replies
2. Shell Programming and Scripting
Hi All,
this is my second post, last post reply was very helpful.
I have a data that has date in DD/MM/YYYY (07/11/2008) format i want to replace the backslash by a dot(.) so that my awk script can read it inside the C shell script that i have written.
i want to change 07/11/2008 to... (3 Replies)
Discussion started by: asirohi
3 Replies
3. Shell Programming and Scripting
Hi I have a date format in a variable as Mon Jan 11 03:35:59 2010. how do i change it to YYYYMMDD format (3 Replies)
Discussion started by: keerthan
3 Replies
4. Shell Programming and Scripting
Hi,
Please can I have some command to get yesterday in YYMMDD format?
This will be used in ksh
Thanks, (2 Replies)
Discussion started by: smalya
2 Replies
5. Shell Programming and Scripting
Hi Guys,
Can someone help me on how to change the date format using sed or any unix command to give my desired output as shown below.
INPUT FILE:
69372,200,20100122T17:56:02,2
53329,500,20100121T11:50:07,2
48865,100,20100114T16:08:16,2
11719,200,20100108T13:32:20,2
DESIRED... (2 Replies)
Discussion started by: pinpe
2 Replies
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
Hi all,
I have a file that every line starts with the date and time. The format is like YYYYMMDDHHMM and I woulk like to change it to MM/DD/YY<space>HH:MM.
I tried to figure out a way to do it with sed, but I don't know how I could reorganize the digits of the first format. Does anyone have any... (1 Reply)
Discussion started by: geovas
1 Replies
8. Shell Programming and Scripting
Hi,
I was looking for a script to change the date from one format to other. A search in the forum gave me the below script as a result.
#! /bin/ksh
format=YYYYMMDD
YEAR=${format%????}
DAY=${format#??????}
MON=${format#$YEAR}
MON=${MON%$DAY}
echo $MON/$DAY/$YEAR
I got it... (2 Replies)
Discussion started by: prithvirao17
2 Replies
9. Shell Programming and Scripting
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
10. UNIX for Beginners Questions & Answers
Hi,
I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates
From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk.
Test run as below:
$: cat xyz.txt
A ... (2 Replies)
Discussion started by: newbie_01
2 Replies
LEARN ABOUT DEBIAN
html::formhandler::field::date
HTML::FormHandler::Field::Date(3pm) User Contributed Perl Documentation HTML::FormHandler::Field::Date(3pm)
NAME
HTML::FormHandler::Field::Date - a date field with formats
VERSION
version 0.40013
SUMMARY
This field may be used with the jQuery Datepicker plugin.
You can specify the format for the date using jQuery formatDate strings or DateTime strftime formats. (Default format is format =>
'%Y-%m-%d'.)
d - "%e" - day of month (no leading zero)
dd - "%d" - day of month (two digit)
o - "%{day_of_year}" - day of the year (no leading zeros)
oo - "%j" - day of the year (three digit)
D - "%a" - day name short
DD - "%A" - day name long
m - "%{day_of_month" - month of year (no leading zero)
mm - "%m" - month of year (two digit) "%m"
M - "%b" - month name short
MM - "%B" - month name long
y - "%y" - year (two digit)
yy - "%Y" - year (four digit)
@ - "%s" - Unix timestamp (ms since 01/01/1970)
For example:
has_field 'start_date' => ( type => 'Date', format => "dd/mm/y" );
or
has_field 'start_date' => ( type => 'Date', format => "%d/%m/%y" );
You can also set 'date_end' and 'date_start' attributes for validation of the date range. Use iso_8601 formats for these dates ("yyyy-mm-
dd");
has_field 'start_date' => ( type => 'Date', date_start => "2009-12-25" );
Customize error messages 'date_early' and 'date_late':
has_field 'start_date' => ( type => 'Date,
messages => { date_early => 'Pick a later date',
date_late => 'Pick an earlier date', } );
If form has 'is_html5' flag active it will render <input type="date" ... /> instead of type="text"
AUTHOR
FormHandler Contributors - see HTML::FormHandler
COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Gerda Shank.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-06-25 HTML::FormHandler::Field::Date(3pm)