10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have been reformatting dates from a data file to make them mysql compliant.
31-10-2011 Loc1
1-11-2011 Loc2
The first can be captured by this:
sed -i '' -e "s#\(..\)-\(..\)-\(....\)#\3-\2-\1#" data.txt
and leads to:
2011-10-31 Loc1
The second line is captured as follows:
sed -i... (2 Replies)
Discussion started by: figaro
2 Replies
2. UNIX for Dummies Questions & Answers
I have a file with temperature measurements:
Loc1,20090102,71.55
Loc1,20090103,71.65
Loc1,20090104,71.55
Loc1,20090105,71.54
Loc1,20090106,71.54
However, to load this into a database I would like to reformat the dates (column 2) from the yyyymmdd format to the yyyy-mm-dd format. I have... (2 Replies)
Discussion started by: figaro
2 Replies
3. UNIX for Dummies Questions & Answers
I currently have the following file containing sample values for a number of dates:
Loc1 04 Jan 2007 0.95 0.9532
Loc1 05 Jan 2007 0.95 0.9513
Loc1 06 Jan 2007 0.95 0.9535
This continues for all months of the year and spans across several years.
I am trying to reformat the dates so that... (2 Replies)
Discussion started by: figaro
2 Replies
4. Shell Programming and Scripting
I read man page for etc/shadow field..
on the 8th field, i assume that's the field to change account expire date.
my question is:
What value does the 8th field keep? i assume it's 13514 instead of "Date" value such as 11/10/08.
on the man page, it said: " expire value = 13514 = jan 1,... (11 Replies)
Discussion started by: c00kie88
11 Replies
5. Shell Programming and Scripting
Hi,
My file format is:
E102,0,21-04-2007,0,2/25/1994,E003,A,125400,10450,60.2884620
E103,0,21/04/2007,0,2/2/1996,E003,A,125400,10450,60.2884620
E104,0,04/21/2007,0,2/2/1996,E003,A,125400,10450,60.2884620
E105,0,21-APR-2007,0,2/2/1996,E003,A,125400,10450,60.2884620... (1 Reply)
Discussion started by: charandevu
1 Replies
6. Shell Programming and Scripting
Hi,
My file format is:
E102,0,21-04-2007,0,2/25/1994,E003,A,125400,10450,60.2884620
E103,0,21/04/2007,0,2/2/1996,E003,A,125400,10450,60.2884620
E104,0,04/21/2007,0,2/2/1996,E003,A,125400,10450,60.2884620
E105,0,21-APR-2007,0,2/2/1996,E003,A,125400,10450,60.2884620... (1 Reply)
Discussion started by: charandevu
1 Replies
7. Shell Programming and Scripting
Hi,
I am getting some very strange output when using date function in PERL on Solaris.
Infact the month portion is wrong and it is 1 less then the current, means today it is responding as
month =3 , andthis should be 4 ------> April
Any help
my code is
($day, $month, $year) =... (3 Replies)
Discussion started by: Asteroid
3 Replies
8. Shell Programming and Scripting
hi,
I have to ftp previous days file from a directory to another location. The name of the files are like "xxx20060225" (yyyymmdd format)
"xxx20060226"
ls -lrt xxx*| tail -2| head -1 will give me the file, but if i could get anything... (2 Replies)
Discussion started by: abey
2 Replies
9. UNIX for Dummies Questions & Answers
I am using this function to calculate yesterday's date and return it in the following format: Jan 09
date '+%b %d %Y' |
{
read MONTH DAY YEAR
DAY=`expr "$DAY" - 1`
case "$DAY" in
0)
MONTH=`expr "$MONTH" - 1`
case "$MONTH" in
... (4 Replies)
Discussion started by: ssmiths001
4 Replies
10. UNIX for Dummies Questions & Answers
hi guys!
just want to ask if you could help me with the sript i'm working on. i need to automatically generate a summarized report everyday for all transactions the day before and ftp it to another machine. my only problem is that i need to name the file as the date yesterday. for example if i... (12 Replies)
Discussion started by: crpalermo
12 Replies