Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date Manipulation
Top Forums Shell Programming and Scripting Date Manipulation Post 302400018 by devtakh on Tuesday 2nd of March 2010 05:09:41 AM
Old 03-02-2010
Simplified to understand...can be optimized.

Code:
#!/usr/bin/perl
$str='"7/3/2009 09:07:12 PM","xxxx"' ;
$str =~ s/\"//g ;
@arr=split(/,/, $str);
@datestr=split(/ /,$arr[0]);
@daystr=split(/\//,$datestr[0]);
@timearr=split(/:/, $datestr[1]);
$merid=$datestr[2];

if ($merid =~ m/PM/ )
{
	if ( $merid ge 10 ) {
           $hour = 12 + $timearr[0];
           }
        else {
           $hour= 24 - $timearr[0];
       }
}
else
{
$hour=$timearr[0];
}

if ($daystr[0] =~ m/\d\d/) {
       $month=$daystr[0];
  }
else
{
    $month="0".$daystr[0];
}
if ($daystr[1] =~ m/\d\d/) {
       $day=$daystr[1];
  }
else
{
    $day="0".$daystr[1];
}
$year=$daystr[2];

$daystr='"'.$year.$day.$month.'", ';
$timestr='"'.$hour.":".$timearr[1].":".$timearr[2].'", ';
$val='"'.$arr[1].'"';

printf("%s%s%s",$daystr,$timestr,$val,);


cheers,
Devaraj Takhellambam
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

date manipulation

I'm writing a ksh script in which I want to present the user with a choice of choosing any of the last 15 days. i.e., a list like the following: 20040510 (today) 20040509 (yesterday) 20040508 . . . 20040426 Is there an easy way to produce the date from x number of days ago other than... (3 Replies)
Discussion started by: jalburger
3 Replies

2. Shell Programming and Scripting

Date Manipulation

I need to achieve the following.....I seached the forum but could not find it... This is I have in a file... "CH","TIA","10/27/2006",000590 I need the date in the third field to be attached to fileas 20061027_test.txt How do I do it. (6 Replies)
Discussion started by: mgirinath
6 Replies

3. Shell Programming and Scripting

Manipulation of Date in Shell

Reuirement: I have a set of files ina diectory which has the name in format "WWW-YYYYmmDD" like, WWW-20070226. for 26th FEB 2007. Now I need to write a shell script which should move the files to directory named "old" in the same directory if date attached to file is 90 days prior to today's... (1 Reply)
Discussion started by: jnanesh.b
1 Replies

4. Shell Programming and Scripting

date manipulation

HI, I'm comparing my file date with the system date and if both the dates are equal I'm doing some operation. I use two variables for these two dates. I use the following command in my query. if .... But here the current date $cd shows 01 and filedate $fdate shows 1. The file is created on 1 of ... (6 Replies)
Discussion started by: pstanand
6 Replies

5. UNIX for Dummies Questions & Answers

Date Manipulation with files

Hi, I have a timestamp stored in a variable start_time=17-JUL-2009 03:45, I need to search a file for this time stamp line by line (where each line has a time stamp in the file) if the time stamp is greater than the start_time variable value need to grep that line for a string and if the string... (2 Replies)
Discussion started by: happyrain
2 Replies

6. Shell Programming and Scripting

Date manipulation

Hi Gurus, How to minus 15 minuets from current system time. For example if current time is " Wed Oct 14 12:12:38 BST 2009", i need "Wed Oct 14 11:57:38 BST 2009" Thanks (2 Replies)
Discussion started by: kumarmani
2 Replies

7. Shell Programming and Scripting

Date manipulation

How can i print a future time, so i get current time by date "+%H:M" but how can i say add 20 minutes to the current time and display as I have just done for current time. (1 Reply)
Discussion started by: kelseyh
1 Replies

8. Shell Programming and Scripting

Date Manipulation and Comparision

Hi All, I want to generate quarter dates using awk or anything, by giving a dates as input for example : start_date=2010-01-01 end_date=2010-05-31 output should be: start_date end_date qtr 2010-01-01 2010-03-31 1 2010-04-01 2010-05-31 2 Example 2:... (1 Reply)
Discussion started by: sol_nov
1 Replies

9. Shell Programming and Scripting

Date manipulation

In my shell script I take date as a input parameter from command line in the format "21 Oct 2011" which would be date +'%d %b %Y' Now i need to do two things here. 1) Validate the date entered by user 2) Calculate yesterday's date from the input. So in this case it should be: "20 Oct 2011"... (9 Replies)
Discussion started by: davidtd
9 Replies

10. Shell Programming and Scripting

Date-Manipulation-1

Hallo Team I can perform the task manually but i would like to automate this process. ok here goes. I have a perl script which runs every Wednesday every week and the name of the script is check_19.pl This is how the script looks like : #!/usr/bin/perl -w #use strict; use DBI; #... (1 Reply)
Discussion started by: kekanap
1 Replies

LEARN ABOUT OSF1

sortm

sortm(1)						      General Commands Manual							  sortm(1)

NAME

       sortm - sort messages (only available within the message handling system, mh)

SYNOPSIS

       sortm [msgs] [+folder] [options]

OPTIONS

       Specifies  the name of the header field to use when making the date comparison. If you have a special field in each message, such as Deliv-
       ery-Date:, then the -datefield switch can be used to tell sortm which field to examine. If you do not give this option, the default  is	to
       use  the  Date:	header	field.	Prints a list of all the valid options to this command.  Displays the general actions that it is taking to
       place the folder in sorted order. The -noverbose option performs these actions silently. The default is -noverbose.

       The default settings for this command are:

       +folder defaults to the current folder msgs defaults to all -datefield date -noverbose

DESCRIPTION

       The command sortm sorts all the messages in the current folder into chronological order according to the contents of the  Date:	fields	of
       the messages.

       By  default, sortm sorts all the messages in the current folder. You can select particular messages in the folder by giving a range of mes-
       sages. You can also sort messages in another folder by specifying the folder name.

       If sortm encounters a message without a Date: field, or if the message has a Date: field that sortm cannot parse, it attempts to  keep  the
       message	in  the  same  relative  position. However, this does not always work; for instance, if the first message encountered lacks a date
       which can be parsed, then it will usually be placed at the end of the messages being sorted.

       When sortm complains about a message which it cannot order, it complains about the message number prior to sorting.

PROFILE COMPONENTS

       Path: To determine your MH directory

EXAMPLES

       The following example sorts all the messages in the folder +meetings: % sortm +meetings The next example sorts messages 10-30 in the folder
       called +test: % sortm +test 10-30

FILES

       The user profile.

SEE ALSO

       folder(1)

																	  sortm(1)
All times are GMT -4. The time now is 02:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy