Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Format date from MM/DD/YYYY to YYYYMMDD Post 302300675 by ChicagoBlues on Tuesday 24th of March 2009 06:23:20 PM
Old 03-24-2009
Format date from MM/DD/YYYY to YYYYMMDD

I have a file with some date columns in MM/DD/YYYY format:

SMPBR|DUP-DO NOT USE|NEW YORK||16105|BA5270715|6/6/2007 |MWERNER|109||||JOHN||SMITH|MD|72211118||||||74559|21 WILMINGTON RD||D|11/6/2003|SL# MD CONTACT-LIZ RICHARDS|||0|Y|N||1411458|

And I want to convert the date format to:

SMPBR|DUP-DO NOT USE|NEW YORK||16105|BA5270715|20070606|MWERNER|109||||JOHN||SMITH|MD|72211118||||||74559|21 WILMINGTON RD||D|20031106|SL# MD CONTACT-LIZ RICHARDS|||0|Y|N||1411458|

Thanks,

-CB
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

get yesterday date in yyyymmdd format

I would like to know how I could get a yesterday date in yyyymmdd e.g. today is 20011109, and I would like to get 20011108. Thank you!:confused: (2 Replies)
Discussion started by: hk_newbie
2 Replies

2. HP-UX

How can i get the yesterday's date in YYYYMMDD format

How can i get the yesterday's date in YYYYMMDD format??? (4 Replies)
Discussion started by: prasadsr
4 Replies

3. Shell Programming and Scripting

convert date format YYYYMMDD to MM/DD/YYYY

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks. (8 Replies)
Discussion started by: nasirgondal
8 Replies

4. Shell Programming and Scripting

PERL String to Date (Custom format yyyymmdd to dd-mon-yyyy)

Hi All, I am learning PERL for one of the projects, and in one of these scripts, I read a flat text file and print in the terminal. The problem is, the text file has a date field. The format is yyyymmdd. I need to display this as dd-mon-yyyy. Any ideas to do this? Thanks a lot for the... (9 Replies)
Discussion started by: guruparan18
9 Replies

5. Solaris

Date after 5 dates in YYYYMMDD format

Hi Experts, How to get date 5 days after current date in YYYYMMDD format? How do we compare date in YYYYMMDD format? Thanks (1 Reply)
Discussion started by: needyourhelp10
1 Replies

6. Shell Programming and Scripting

Date after 5 days from current date in YYYYMMDD format

Hello Experts, How do i get date after 5 days from current date in YYYYMMDD format? How do you compare date in YYYYMMDD format? Thanks (8 Replies)
Discussion started by: needyourhelp10
8 Replies

7. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies

8. Shell Programming and Scripting

Converting Date from YYYYMMDD to DD-MON-YYYY

Hi , I need to convert date from YYYYMMDD to DD-MON-YYYY e.g 20111214 to 14-Dec-2011 Please help. (17 Replies)
Discussion started by: ady_koolz
17 Replies

9. Shell Programming and Scripting

Date format YYYY/MM/DD to DD/MM/YYYY

I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY. When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD file... (3 Replies)
Discussion started by: Roozo
3 Replies

10. Programming

Date format change from mm/dd/yyyy to yyyymmdd in comma seperate line in perl

Hi All, I have line ,A,FDRM0002,12/21/2017,,0.961751583,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, it contains date in mm/dd/yyyy format i want to change this to yyyymmdd format using perl. Use code tags, thanks. (8 Replies)
Discussion started by: vishal0746
8 Replies
iCal::Parser::HTML(3pm) 				User Contributed Perl Documentation				   iCal::Parser::HTML(3pm)

NAME
iCal::Parser::HTML - Generate HTML calendars from iCalendars SYNOPSIS
use iCal::Parser::HTML; my $parser=iCal::Parser::HTML->new; print $parser->parse(type=>$type,start=>$date,files=>[@icals]); DESCRIPTION
This module uses iCal::Parser::SAX and XML::LibXSLT with included stylesheets to generates html calendars from icalendars. The html document generated includes (when appropriate) a sidebar containing a legend, a list of todos and a three month calendar for the previous, current and next months. The stylesheets are stored in the HTML/stylesheet directory under the installed package directory. Also included in this package are an optionally installed command line program "ical2html" in scripts and, in the example directory, a cgi handler ("ical.cgi" in examples) and a stylesheet ("calendar.css" in examples) for formatting the html output. Note that the html output will look quite broken without the stylesheet. ARGUMENTS
The following arguments are processed by this module. Any addtional arguments are passed to iCal::Parser::SAX. type The type of calendar to generate. One of: "day", "week", "month" or "year". The daily, weekly and monthly calendars include the sidebar. The calendar generated will be for the specified period (day, week, etc.) which includes the specified date. start The date to generated the calendar for. The date only needs to be specified to the precision necessary for the type of calendar. That is, "YYYY" for a yearly calendar, "YYYYMM" for a monthly, and "YYYYMMDD" for daily and weekly. In addition, the date can be in one of the following forms: YYYY[MM[DD]] YYYY[-MM[-DD]] A DateTime object initialized to the necessary precision files An array reference to the list of icalendars to include in the results. url If this params is specified, then the html output will contain links back to this url for getting other calendar periods. The params "type" and "date" will be appended to this url when generating the links. AUTHOR
Rick Frankel, cpan@rickster.com COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module. SEE ALSO
iCal::Parser::SAX, XML::LibXML::SAX::Builder, XML::LibXSLT, DateTime perl v5.14.2 2012-01-25 iCal::Parser::HTML(3pm)
All times are GMT -4. The time now is 12:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy