Sponsored Content
Top Forums Shell Programming and Scripting Csv files sort by date and zip monthly Post 303024687 by Pipo on Monday 15th of October 2018 03:43:55 AM
Old 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

Zip files by date

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

Need to zip the files date wise --urgent Help needed

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

List files with Date Range and Zip it

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

How to insert variable date (monthly) from SQL script

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

Sort and join all .csv files

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

Sort, sed, and zero padding date column csv bash 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

How to zip csv files having specific pattern in a directory using UNIX shell script?

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

How can we Zip multiple files created on the same date into one single zip file.?

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

How can we Zip multiple files created on the same date into one single zip file.?

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

Changing CSV files with date . Subtracting date by values

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
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)
All times are GMT -4. The time now is 01:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy