10-09-2008
File Handling
Hi,
I have a log file which runs into 3 to 5 GB.
We store this typically for 6 months. When a new month starts we move the previous month into a 9 month back up log (file.9m) and delete the last month of the 9 month back up.
Iam using awk to find the data and cat to join the files like below
BEGIN { FS = "|"}
{ if (($5 == "09") && ($6 == "08")) print $0 >> "/file.1m";
}
END { print "script processed " NR}
in the above $5 is month and $6 is the year and the log file has pipe separated columns
cat /file.6m /new.log > /file.temp
mv /file.temp /new.log
the file.6m is the back up file when a new month starts and the new.log is the running log.
similarly I extract file.1m(last month) from file.6m and file.8m ( eight months without the last month from the file.9m) and join using cat as above.
This process though is NOT neat, is yielding the result.
I would like to know if there is any better of doing this. Since the file is really large sometimes i find the data jumbled up.
Appreciate your inputs.
10 More Discussions You Might Find Interesting
1. Programming
Hi all,
I have a problem in handling files through C.
here is the problem im having:
i will query the database (for instance consider employees table )
for empno,ename,job,salary fields.The query returns me some 100 of rows. now i need to place them in a file in row wise pattern as they... (3 Replies)
Discussion started by: trinath
3 Replies
2. Programming
Hi all,
I got a little issue here. Imagine that I have more than one process accessing one file. Is it possible to know which process(es) are accessing that file when I open the file??
Thanks for the help.
Best regards,
Ernesto (2 Replies)
Discussion started by: ninjanesto
2 Replies
3. UNIX for Advanced & Expert Users
sir i have to get first line from a file
for example
>cat file1
abc
zxc
asd
adsf
from that file1 i need only first line
expected result
>abc
please help me ! (1 Reply)
Discussion started by: ponmuthu
1 Replies
4. UNIX for Advanced & Expert Users
my input for a script is another csv file
but in that file say 7 lines are there ...
how can i get line by line to that input
for example :
>cat link.csv
www.yahoo.com,yahoo
www.google.com,google
www.unix.com,unix
another file
in that file i need to ping the above links
... (2 Replies)
Discussion started by: ponmuthu
2 Replies
5. Shell Programming and Scripting
I have been doing automation of daily check activity for a server, i have been using sqls to retrive the data and while loop for reading the data from the file for several activities. BUT i got a show stopper the below one.. where the data is getting store in $temp_file, but not being read by while... (1 Reply)
Discussion started by: KuldeepSinghTCS
1 Replies
6. Programming
$# some text
$$ some text
$@ some text
$$. some text
Mg1 some text
Mg2 some text
.
.
.
Mg10 some text
The above 10 lines are to be extracted except the lines starting from $#,$$.,... (4 Replies)
Discussion started by: baig.abdul
4 Replies
7. Shell Programming and Scripting
Specifically on RHEL 5.7.
When does the underlying ksh process open and close files? Every time they're accessed, or as little as possible?
Say you have some script like:
CreateFiles()
{
grep "<VALUE1>" ${infile} >> ${outfile}
grep "<VALUE2>" ${infile} >> ${outfile}
...... (4 Replies)
Discussion started by: CarloM
4 Replies
8. UNIX for Dummies Questions & Answers
Hi Team,
I am trying to cut a large file into multiple files. It has
Header
50,050 records
Trailer
-------------------------------------------
I need to cut the files into multiple files of 1000 records and should have the same header and trailer as the original files.
... (4 Replies)
Discussion started by: Gurkamal83
4 Replies
9. UNIX for Dummies Questions & Answers
I have a file
1
298167
298168
1093209
1093210
1422663
I want to write a code where in I want to read contents of above file
like first read is 1
second read is 298167
Substract second read from first and if this is greater than or less than 99,999.
Similarly I want to traverse thru... (3 Replies)
Discussion started by: Guru148
3 Replies
10. Shell Programming and Scripting
Hi All,
I need to extract the data from the text file. The data of the text file is shown below
#L 0.000017 4.329939 0.000017 4.716267 r7.9 P 1 1;Net=IN32
The extracted data should be IN32. Could anyone help to script in c shell.? (4 Replies)
Discussion started by: gopishrine
4 Replies
LEARN ABOUT DEBIAN
calendar::simple
Calendar::Simple(3pm) User Contributed Perl Documentation Calendar::Simple(3pm)
NAME
Calendar::Simple - Perl extension to create simple calendars
SYNOPSIS
use Calendar::Simple;
my @curr = calendar; # get current month
my @this_sept = calendar(9); # get 9th month of current year
my @sept_2002 = calendar(9, 2002); # get 9th month of 2002
my @monday = calendar(9, 2002, 1); # get 9th month of 2002,
# weeks start on Monday
my @span = date_span(mon => 10, # returns span of dates
year => 2006,
begin => 15,
end => 28);
DESCRIPTION
A very simple module that exports one function called "calendar".
calendar
This function returns a data structure representing the dates in a month. The data structure returned is an array of array references. The
first level array represents the weeks in the month. The second level array contains the actual days. By default, each week starts on a
Sunday and the value in the array is the date of that day. Any days at the beginning of the first week or the end of the last week that are
from the previous or next month have the value "undef".
If the month or year parameters are omitted then the current month or year are assumed.
A third, optional parameter, start_day, allows you to set the day each week starts with, with the same values as localtime sets for wday
(namely, 0 for Sunday, 1 for Monday and so on).
date_span
This function returns a cur-down version of a month data structure which begins and ends on dates other than the first and last dates of
the month. Any weeks that fall completely outside of the date range are removed from the structure and any days within the remaining weeks
that fall outside of the date range are set to "undef".
As there are a number of parameters to this function, they are passed using a named parameter interface. The parameters are as follows:
year
The required year. Defaults to the current year if omitted.
mon The required month. Defaults to the current month if omitted.
begin
The first day of the required span. Defaults to the first if omitted.
end The last day of the required span. Defaults to the last day of the month if omitted.
start_day
Indicates the day of the week that each week starts with. This takes the same values as the optional third parameter to "calendar". The
default is 0 (for Sunday).
This function isn't exported by default, so in order to use it in your program you need to use the module like this:
use Calendar::Simple 'date_span';
EXAMPLE
A simple "cal" replacement would therefore look like this:
#!/usr/bin/perl -w
use strict;
use Calendar::Simple;
my @months = qw(January February March April May June July August
September October November December);
my $mon = shift || (localtime)[4] + 1;
my $yr = shift || (localtime)[5] + 1900;
my @month = calendar($mon, $yr);
print "
$months[$mon -1] $yr
";
print "Su Mo Tu We Th Fr Sa
";
foreach (@month) {
print map { $_ ? sprintf "%2d ", $_ : ' ' } @$_;
print "
";
}
A version of this example, called "pcal", is installed when you install this module.
Date Range
This module will make use of DateTime.pm if it is installed. By using DateTime.pm it can use any date that DateTime can represent. If
DateTime is not installed it uses Perl's built-in date handling and therefore can't deal with dates before 1970 and it will also have
problems with dates after 2038 on a 32-bit machine.
EXPORT
"calendar"
AUTHOR
Dave Cross <dave@mag-sol.com>
ACKNOWLEDGEMENTS
With thanks to Paul Mison <cpan@husk.org> for the start day patch.
COPYRIGHT
Copyright (C) 2002-2008, Magnum Solutions Ltd. All Rights Reserved.
LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
perl, localtime, DateTime
perl v5.10.1 2010-04-02 Calendar::Simple(3pm)