10-15-2018
Csv files sort by date and zip monthly
Hi,
I'm an absolute beginner in shell programming.
I would need a script for a NAS that makes the csv files sorted by date and always monthly a zip.
In the current month, the data should be integrated into this folder, so there are only monthly files.
Thanks for your help
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I need to create a bash script file that zip files.
The obj is : the script enter into a directory, see all directories, and zip the files by date ( the script is for managment of logfiles ), exemple: in the directory there is just files following the name "ex090210" (yymmdd ), so i need... (1 Reply)
Discussion started by: joinup
1 Replies
2. Shell Programming and Scripting
Hi all,
this is my first post, i need to write a script to zip the files with datewise below are the log files.
-rw------- 1 root sso 85316156 May 24 22:11 core_test_smservaz_104_104_1243217459_8896
-rw------- 1 root sso 90413304 May 25 22:12 core_test_smservaz_104_104_1243303895_20912... (4 Replies)
Discussion started by: lcschandu
4 Replies
3. Shell Programming and Scripting
Hi all,
I am using the below script which display the files in the folder with the date range we specify. I want to add extra functionality that,
The listing files should be zipped using gzip. I tried to add exec gzip at the last line but it is not working.
Suggestions please.
... (2 Replies)
Discussion started by: nokiak810
2 Replies
4. Shell Programming and Scripting
Hi Guys,
Can someone please help me on adding/inserting a variable to an sql scipt? Basically I want to generate data on monthly (i.e. July 01, 2011 to July 31, 2011) basis. As shown below..
set head off;
set linesize 300;
set pagesize 200;
spool /opt/oracle/temp/output.txt
select... (1 Reply)
Discussion started by: pinpe
1 Replies
5. UNIX for Dummies Questions & Answers
Hi ,
I have a dump of .csv files in a folder, I need to sort all files by the first 3 columns and merge them all in one big csv file.
I am using a cat command to join them, but how can i sort before appending all the files as one big file,
Regards,
Shruthi (4 Replies)
Discussion started by: shruthidwh
4 Replies
6. Shell Programming and Scripting
Hello people,
I am having problem to sort, sed and zero padding of column in csv file.
7th column only.
Input of csv file:
1,2,3,4,5,6,4/1/2010 12:00 AM,8
1,2,3,4,5,6,3/11/2010 9:39 AM,8
1,2,3,4,5,6,5/12/2011 3:43 PM,8
1,2,3,4,5,6,12/20/2009 7:23 PM,8
Output:... (5 Replies)
Discussion started by: sean1357
5 Replies
7. UNIX for Beginners Questions & Answers
I have files in a Linux directory . Some of the file is listed below
-rw-rw-r--. 1 roots roots 0 Dec 23 02:17 zzz_123_00000_A_1.csv
-rw-rw-r--. 1 roots roots 0 Dec 23 02:18 zzz_121_00000_A_2.csv
-rw-rw-r--. 1 roots roots 0 Dec 23 02:18 zzz_124_00000_A_3.csv
drwxrwxr-x. 2 roots roots 6 Dec 23... (4 Replies)
Discussion started by: Balraj
4 Replies
8. UNIX for Beginners Questions & Answers
Hi all i am very new to shell scripting and need some help from you to learn
1)i have some log files that gets generated on daily basis example: i have abc_2017_01_30_1.log ,2017_01_30_2.log like wise so i want to zip this 4 logs which are created on same date into one zip folder.
2)Post zipping... (2 Replies)
Discussion started by: b.saipriyanka
2 Replies
9. Shell Programming and Scripting
Hi all i am very new to shell scripting and need some help from you to learn
1)i have some log files that gets generated on daily basis example: i have abc_2017_01_30_1.log ,2017_01_30_2.log like wise so i want to zip this 4 logs which are created on same date into one zip folder.
2)Post zipping... (1 Reply)
Discussion started by: b.saipriyanka
1 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I have a CSV file which is as below. Basically I need to take the year column in it and find if the year is >= 20152 . If that is then I should subtract all values by 6. In the below example in description I am having number mentioned as YYWW so I need to subtract those by -5. Whereever... (8 Replies)
Discussion started by: arunkumar_mca
8 Replies
LEARN ABOUT DEBIAN
ical::parser::sax
iCal::Parser::SAX(3pm) User Contributed Perl Documentation iCal::Parser::SAX(3pm)
NAME
iCal::Parser::SAX - Generate SAX events from an iCalendar
SYNOPSIS
use iCal::Parser::SAX;
my $parser=iCal::Parser::SAX->new(Handler=>SAXHandler,%args);
$parser->parse_uri($file);
$parser->parse_uris(@files);
DESCRIPTION
This module uses iCal::Parser to generates SAX events for the calendar contents.
The xml document generated is designed for creating monthly calendars with weeks beginning on monday (e.g., by passing the output through
an xsl styleheet).
The basic structure of the generated document (if output through a simple output handler like "XML::SAX::Writer"), is as follows:
<ical>
<calendars>
<calendar id="cal-id" index="n" name="..." description="..."/>
</calendars>
<events>
<year year="YYYY">
<month month="[1-12]">
<week week="n">
<day date="YYYY-MM-DD">
<event uid="event-id" idref="cal-id" [all-day="1"]>
<!-- ... -->
</event>
</day>
</week>
</month>
</events>
<todos>
<todo idref="cal-id" uid="...">
<!--- ... -->
</todo>
</todos>
</ical>
Along with basics, such as converting calendar attributes to lowercase elements (e.g., a "DTSTART" attribute in the input would generate a
sax event like "element({Name="'dtstart'})>), a number of other processes occur:
o "day" elements are are generated for each date within the months from the first month in the input to the last, even if there are no
calendar events on that day. This guarantees a complete calendar month for further processing. If there is an overlap between two or
more events, the attribute "conflict", containing the number of concurrent overlaps, is added to the element.
o If the beginning or end of the month does not start on a monday, or end on a sunday, the days from the previous (next) month month are
duplicated within the first (last) week of the current month, including duplicate copies of any calendar events occuring on those days.
This allows for displaying a monthly calendar the same way a program such as Apple's iCal would, with calendar events showing up if
they fall within the overlapping days in the first or last week of a monthly calendar.
METHODS
Along with the standard SAX parsing methods "parse_uri", "parse_file", etc.), the following methods are supported.
new(%args)
Create a new SAX parser. All arguments other than "Handler" and "no_escape" are passed to iCal::Parser.
Arguments
Handler
The SAX handler.
no_escape
If not set, quotes, ampersands and apostrophes are converted to entites. In any case < is converted to an entity, "\n" is converted
to the return entity and double backslashes ("\") are removed.
parse_uris(@uris)
Pass all the input uris to "iCal::Parser" and generate a combined output calendar.
parse_hash($hash)
Parse the hash returned from iCal::Parser::calendar directly.
AUTHOR
Rick Frankel, cpan@rickster.com
COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
SEE ALSO
iCal::Parser, XML::SAX::Base
perl v5.14.2 2012-08-05 iCal::Parser::SAX(3pm)