when i run this command:
Code:
tail -200 /var/log/httpd/access_log | awk -F'[][]' '{sub(/:[^:]*$/,"",$2);print $2}'
i get:
Code:
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
13/Aug/2012:20:56
now i need to alter the awk command
I have an input list of:
Quote:
2/10/2012 9:19 PM EST
2/10/2012 8:48 PM EST
2/16/2012 2:49 PM EST
2/16/2012 6:06 PM EST
2/14/2012 8:30 PM EST
2/13/2012 2:44 PM EST
2/13/2012 6:06 PM EST
2/14/2012 4:36 PM EST
2/11/2012 7:01 PM EST
2/16/2012 11:48 AM EST
2/15/2012 6:16 PM EST
2/13/2012 12:59 PM EST
I am just trying to turn this list into its seconds
Hi
my data is in csv-format ...
Code:
...
13/08/2012,16:30,303.30,5.10,3,2,2,1,9360.0,322
13/08/2012,16:40,305.50,5.00,3,2,2,1,12360.0,322
13/08/2012,16:50,319.90,3.80,3,2,1,0,2280.0
13/08/2012,17:00,326.10,3.50,3,2,1,1,4380.0,321
13/08/2012,17:10,333.00,3.80,3,3,1,0,2280.0
13/08/2012,17:20,330.20,4.50,3,3,2,0,2700.0
13/08/2012,17:30,332.00,4.20,3,3,2,1,5220.0,332
13/08/2012,17:40,334.90,3.
The error is 2147746321.
I can see in the mailserver log that it tries, but the connection gets closed.
A part of the output from the ps -ef command is given below :
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 2012 ? 00:00:01 init [3]
root 2 1 0 2012 ? 00:00:01 [migration/0]
root 3 1 0 2012 ? 00:00:00 [ksoftirqd/0]
root 4 1 0 2012 ? 00:00:00 [watchdog/0]
root 5 1 0 2012 ?
Hello,
I have example data like below:
Code:
39 ,2012/01,0
22 ,2012/02,0
2 ,2012/02,1
23 ,2012/03,0
3 ,2012/03,1
16 ,2012/04,0
2 ,2012/04,1
8 ,2012/05,0
2 ,2012/05,1
It is possible (awk, sed, bash) to calculate output like below
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1.
I have an SQL fact table which is used for looking up a date and returning another date.
The table schema is as follows:
TABLE date_lookup
(
pk_date DATE,
plus1_months DATE,
plus2_months DATE,
plus3_months DATE
);
UNIQUE INDEX on date_lookup(pk_date);
I have a load file (pipe delimited) containing dates from 01-28-2012 to 03-31-2014.
The following is an example of the load file:
01-2
Hi
I have a large csv file with lines like below
Code:
Date,Status,orig,dest,in,out,when,where
2012-01-01 00:30:37,I,48,56,23,98,83,34
2012-06-17 15:00:38,I,72,43,12,65,34,12
I will really appreciate if someone can help with a sed script to transpose this to
Code:
2012-01-01 00:30:37,I,orig,48
2012-01-01 00:30:37,I,dest,56
2012-01-01 00:30:37,I,in,23,
2012-01-01 00:30:37,I,out,98
201