08-26-2008
Problem solved! Thanks for all your help!
How would I export the excel version into a Windows env for further processing?
CURRENT_DATE=`date "+%b%d"`
echo "$CURRENT_DATE"
OLD1=`date "+%b"`
OLD2=`expr "$OLD1 - 1"`
OLD_ONE=`date "+%b%Y"`$OLD2
echo"$OLD_DATE"
CURRENT_DATE=`date "+%b%d%Y"`
echo "$CURRENT_DATE"
OLD1=`date "+%d"`
OLD2=`expr $OLD1 - 1`
OLD_ONE=`date "+%b"`$OLD2
echo "$OLD_ONE"
rm -rf *.xls
chmod 777 file_file_perf_$OLD_ONE.csv
awk -f csc2xls < file_file_perf_$OLD_ONE.csv > file_file_perf_$OLD_ONE.xls
chmod 777 file_file_perf_$OLD_ONE.xls
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All,
How to find a date which is 7 days from the current date as well as how to find a date which is 7 days before this current date.
Urgently i need help.
Thanks in Advance
Regards
Arunava (2 Replies)
Discussion started by: arunava_maity
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
How do you find the create date of a directory? I can see the modification date using ls -l but I'm looking for the create date.
Many thanks
Helen (2 Replies)
Discussion started by: Bab00shka
2 Replies
3. Shell Programming and Scripting
So I need to create a shell script that can take as input a numeric day, month and year and output the day of the week for the input date.
So let's say, I input "programname 19 10 2006" it should output Thursday... I tried messing around with the grep and awk commands, but I can't get it to... (6 Replies)
Discussion started by: mredwardlee
6 Replies
4. UNIX for Advanced & Expert Users
Hi ,
I have written a shell script that takes the current date on the server and stores it in a file.
echo get /usr/home/data-`date '+%Y%d'`.xml> /usr/local/sandeep/GetFILE.ini
I call this GetFILE.ini file from an sftp program to fetch a file from /usr/home/ as location. The file is in... (3 Replies)
Discussion started by: bsandeep_80
3 Replies
5. Shell Programming and Scripting
hii all.
I have to get the date of the 7th day past from the current date.
if i give the current date as sep 3 then i must get the date as 27th of august.
can we get the values from the "cal" command.
cal | awk '{print $2}' will this type of command work.
actually my need is
if today is... (17 Replies)
Discussion started by: ladtony
17 Replies
6. Shell Programming and Scripting
Hi All,
I want to find the time diffrence between currnt time and "abc.txt" file create time.
I have solve that but if the abc.txt file created last month then is there any process to find the difftent?
Exp:
Create time of abc.txt is "Apr 14 06:48"
and currect date is "May 17 23:47".... (1 Reply)
Discussion started by: priyankak
1 Replies
7. Shell Programming and Scripting
I have a requirement to send a trigger file (trigger_dayn.dat) to a remote server through the FTP
trigger_dayn.dat - here the dayn is the day number. However the dayn is not sysdate.
day 1 is from Monday 07:00.00 AM to Tuesday 06:59:59 AM and so on. So if the trigger file is generated say... (1 Reply)
Discussion started by: k_vikash
1 Replies
8. Shell Programming and Scripting
Hi all,
Need an urgent help on the below scenario.
script:
awk -F","
'BEGIN { #some variable assignment}
{ #some calculation and put values in array}
END {
year=#getting it from array and assume this will be 2014
month=#getting it from array and this will be 05
date=#... (7 Replies)
Discussion started by: vijaidhas
7 Replies
9. UNIX for Dummies Questions & Answers
My unix version is IBM AIX Version 6.1
I tried google my requirement and found the below answer,
find . -newermt “2012-06-15 08:13" ! -newermt “2012-06-15 18:20"
But newer command is not working in AIX version 6.1 unix
I have given my requirement below:
Input:
atr files:
... (1 Reply)
Discussion started by: yuvaa27
1 Replies
10. Shell Programming and Scripting
Hello,
I have files that with a naming convention as shown below. Some of the files have dates in the file name and some of them don't have dates in the file name.
imap-hp-import-20150917.txt
imap-dell-gec-import-20150901.txt
imap-cvs-import-20150915.txt
imap-gec-import.txt... (8 Replies)
Discussion started by: Saanvi1
8 Replies
LEARN ABOUT PHP
datetime.settimezone
DATETIME.SETTIMEZONE(3) 1 DATETIME.SETTIMEZONE(3)
DateTime::setTimezone - Sets the time zone for the DateTime object
Object oriented style
SYNOPSIS
public DateTime DateTime::setTimezone (DateTimeZone $timezone)
DESCRIPTION
Procedural style
DateTime date_timezone_set (DateTime $object, DateTimeZone $timezone)
Sets a new timezone for a DateTime object.
PARAMETERS
o $object
-Procedural style only: A DateTime object returned by date_create(3). The function modifies this object.
o $timezone
- A DateTimeZone object representing the desired time zone.
RETURN VALUES
Returns the DateTime object for method chaining or FALSE on failure.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.0 | |
| | |
| | Changed the return value on success from NULL to |
| | DateTime. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
DateTime.setTimeZone(3) example
Object oriented style
<?php
$date = new DateTime('2000-01-01', new DateTimeZone('Pacific/Nauru'));
echo $date->format('Y-m-d H:i:sP') . "
";
$date->setTimezone(new DateTimeZone('Pacific/Chatham'));
echo $date->format('Y-m-d H:i:sP') . "
";
?>
Procedural style
<?php
$date = date_create('2000-01-01', timezone_open('Pacific/Nauru'));
echo date_format($date, 'Y-m-d H:i:sP') . "
";
date_timezone_set($date, timezone_open('Pacific/Chatham'));
echo date_format($date, 'Y-m-d H:i:sP') . "
";
?>
The above examples will output:
2000-01-01 00:00:00+12:00
2000-01-01 01:45:00+13:45
SEE ALSO
DateTime.getTimezone(3), DateTimeZone.__construct(3).
PHP Documentation Group DATETIME.SETTIMEZONE(3)