10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
we have a CSV which i need to convert to XML using Perl or Unix shell scripting.
I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
Discussion started by: laknar
3 Replies
2. Shell Programming and Scripting
I have absolutaly no idea how to get this script to sort the info in Birthdays.csv by date of birth. I know the sort -n command, however i wish to sort the file birthdays.csv by DOB. How would i go about doing this?
The below script gets user info and date of birth and then puts these info a... (3 Replies)
Discussion started by: redshine6
3 Replies
3. Shell Programming and Scripting
Hi All
How all are doing today. Just struck in an issue in Perl
I have a csv file which contain 32 column, I want to make sorting in that csv file with respect to 26th column.
Is it possible to do so without any module being added?
Regards
Aditya
---------- Post updated at 10:02 AM... (11 Replies)
Discussion started by: adisky123
11 Replies
4. Shell Programming and Scripting
Hello!
So ive been presented with this comma-delimited file:
I need a print to look as below
"
lastname, phone_number, zip
for every person with a last name starting with the letter H, I
only with a 650-area code phone number. output should be sorted by reverse ZIP code "
I only have... (5 Replies)
Discussion started by: strangemachine
5 Replies
5. Shell Programming and Scripting
Hi I have a problem and was wondering if anyone could help?
Anyone can input their full name, email, birth date, gender how can I put this into a comma seperate value file?
And then be able to sort it by their gender?
Any help is appreicated I'm novice! (1 Reply)
Discussion started by: albertne
1 Replies
6. Shell Programming and Scripting
Hello all, I am new here and *relatively* new to Unix. I have a bit of an emergency. I have a three column file that I need to sort:
sample name, miRNA, reads per million (RPM)
There are multiple samples, and for each sample name there are multiple miRNAs and associated RPMs. Some of these... (6 Replies)
Discussion started by: dunnybocter
6 Replies
7. Shell Programming and Scripting
Hi,
I have a CSV file in following manner:
server1,env1,patch1
server1,env1,patch2
server1,env1,patch3
server1,env2,patch1
server1,env2,patch3
server2,env3,patch1
server2,env3,patch5
server2,env4,patch1
server3,env6,patch1
server3,env7,patch2
server3,env7,patch3
I want to... (6 Replies)
Discussion started by: avikaljain
6 Replies
8. Shell Programming and Scripting
Hi all,
in my csv file it'll look like this, and of course it may have more columns
US to UK;abc-hq-jcl;multimedia
UK to CN;def-ny-jkl;standard
DE to DM;abc-ab-klm;critical
FD to YM;la-yr-tym;standard
HY to MC;la-yr-ytm;multimedia
GT to KJ;def-ny-jrt;critical
I would like to group... (4 Replies)
Discussion started by: tententen
4 Replies
9. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
10. Shell Programming and Scripting
Hi,
I have a .csv file which contains script names, subjects and email_addresses
The first two colums are always script name and subject, the next 20 colums are email address..
What i want to do is sort the email address in alphabetical order for each row and there's around 1200 rows.
So... (3 Replies)
Discussion started by: Jazmania
3 Replies
CSV(3pm) User Contributed Perl Documentation CSV(3pm)
NAME
Class::CSV - Class based CSV parser/writer
SYNOPSIS
use Class::CSV;
my $csv = Class::CSV->parse(
filename => 'test.csv',
fields => [qw/item qty sub_total/]
);
foreach my $line (@{$csv->lines()}) {
$line->sub_total('$'. sprintf("%0.2f", $line->sub_total()));
print 'Item: '. $line->item(). "
".
'Qty: '. $line->qty(). "
".
'SubTotal: '. $line->sub_total(). "
";
}
my $cvs_as_string = $csv->string();
$csv->print();
my $csv = Class::CSV->new(
fields => [qw/userid username/],
line_separator => "
";
);
$csv->add_line([2063, 'testuser']);
$csv->add_line({
userid => 2064,
username => 'testuser2'
});
DESCRIPTION
This module can be used to create objects from CSV files, or to create CSV files from objects. Text::CSV_XS is used for parsing and
creating CSV file lines, so any limitations in Text::CSV_XS will of course be inherant in this module.
EXPORT
None by default.
METHOD
CONSTRUCTOR
parse
the parse constructor takes a hash as its paramater, the various options that can be in this hash are detailed below.
Required Options
o fields - an array ref containing the list of field names to use for each row. there are some reserved words that cannot be
used as field names, there is no checking done for this at the moment but it is something to be aware of. the reserved field
names are as follows: "string", "set", "get". also field names cannot contain whitespace or any characters that would not be
allowed in a method name.
Source Options (only one of these is needed)
o filename - the path of the CSV file to be opened and parsed.
o filehandle - the file handle of the CSV file to be parsed.
o objects - an array ref of objects (e.g. Class::DBI objects). for this to work properly the field names provided in fields needs
to correspond to the field names of the objects in the array ref.
o classdbi_objects - depreciated use objects instead - using classdbi_objects will still work but its advisable to update your
code.
Optional Options
o line_separator - the line seperator to be included at the end of every line. defaulting to "
" (unix carriage return).
new the new constructor takes a hash as its paramater, the same options detailed in parse apply to new however no Source Options can be
used. this constructor creates a blank CSV object of which lines can be added via add_line.
ACCESSING
lines
returns an array ref containing objects of each CSV line (made via Class::Accessor). the field names given upon construction are
available as accessors and can be set or get. for more information please see the notes below or the perldoc for Class::Accessor. the
lines accessor is also able to be updated/retrieved in the same way as individual lines fields (examples below).
Example
retrieving the lines:
my @lines = @{$csv->lines()};
removing the first line:
pop @lines;
$csv->lines(@lines);
sorting the lines:
@lines = sort { $a->userid() <=> $b->userid() } @lines:
$csv->lines(@lines);
sorting the lines (all-in-one way):
$csv->lines([ sort { $a->userid() <=> $b->userid() } @{$csv->lines()} ]);
Retrieving a fields value
there is two ways to retrieve a fields value (as documented in Class::Accessor). firstly you can call the field name on the object
and secondly you can call "get" on the object with the field name as the argument (multiple field names can be specified to
retrieve an array of values). examples are below.
my $value = $line->test();
OR
my $value = $line->get('test');
OR
my @values = $line->get(qw/test test2 test3/);
Setting a fields value
setting a fields value is simmilar to getting a fields value. there are two ways to set a fields value (as documented in
Class::Accessor). firstly you can simply call the field name on the object with the value as the argument or secondly you can call
"set" on the object with a hash of fields and their values to set (this isn't standard in Class::Accessor, i have overloaded the
"set" method to allow this). examples are below.
$line->test('123');
OR
$line->set( test => '123' );
OR
$line->set(
test => '123',
test2 => '456'
);
Retrieving a line as a string
to retrieve a line as a string simply call "string" on the object.
my $string = $line->string();
new_line
returns a new line object, this can be useful for to "splice" a line into lines (see example below). you can pass the values of the
line as an ARRAY ref or a HASH ref.
Example
my $line = $csv->new_line({ userid => 123, domainname => 'splicey.com' });
my @lines = $csv->lines();
splice(@lines, 1, 0, $line);
OR
splice(@{$csv->lines()}, 1, 0, $csv->new_line({ userid => 123, domainname => 'splicey.com' }));
add_line
adds a line to the lines stack. this is mainly useful when the new constructor is used but can of course be used with any constructor.
it will add a new line to the end of the lines stack. you can pass the values of the line as an ARRAY ref or a HASH ref. examples of
how to use this are below.
Example
$csv->add_line(['house', 100000, 4]);
$csv->add_line({
item => 'house',
cost => 100000,
bedrooms => 4
});
OUTPUT
string
returns the object as a string (CSV file format).
print
calls "print" on string (prints the CSV to STDOUT).
SEE ALSO
Text::CSV_XS, Class::Accessor
AUTHOR
David Radunz, <david@boxen.net>
COPYRIGHT AND LICENSE
Copyright 2004 by David Radunz
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.0 2007-02-08 CSV(3pm)