Reg - Working on a CSV File in a script

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ...

2. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07...

3. Shell Programming and Scripting

Remove ^L from csv not working...

hello... i have a requirement to convert a xls file to csv in RHEL 6.5 and ftp it to a windows location. i am using xls2csv utility to convert the file in linux. Input xls file attached... I have used below commands to convert the file to csv: xls2csv -x test.xls -s cp1252 -d 8859-1...

4. UNIX for Dummies Questions & Answers

Remodelling the .csv file using the script

Hello All, I have a .csv file named as remark.csv The csv file content looks like below: Remark_Hello_1 Remark_Hello_2 Remark_Hello_3 Remark_Hello_4 Hello_World_FW_0001 X Hello_World_FW_0002 X X Hello_World_FW_0003 X X Hello_World_FW_0004 X X I...

5. Shell Programming and Scripting

Script to generate csv file

Hello; I need to generate a csv file that contains a list of all the files in a particular server (from the root directory ie: \) that have a permission stamp of 777. I would like to create the csv so that it contains the following: server name, file name, full path name where file exists,...

6. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- ----- ---------------------------------...

7. Shell Programming and Scripting

How to convert a excel file to a .csv file from unix script

Hi I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this? Thanks Abhinav

8. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are 1. The Control file name(.ctl file) 2. The Data file name(.csv file) Does anybody have an idea about it? :confused:

9. SCO

reg:rm -R is not working

I am installing the my package in SCO unix 5.0 .so it will create some temporary directories and files and same will delete.So , 'rm -R ' is not working in system .in the package only it has given this command,so now without this command working we can not go forward. so kindly help in this...

LEARN ABOUT DEBIAN

text::csv::encoded::coder::base

Text::CSV::Encoded::Coder::Base(3pm)			User Contributed Perl Documentation		      Text::CSV::Encoded::Coder::Base(3pm)

NAME

       Text::CSV::Encoded::Coder::Base - Interface for Text::CSV::Encoded coder base class

SYNOPSIS

	   package Text::CSV::Encoded::Coder::YourCoder;

	   use base qw( Text::CSV::Encoded::Coder::Base );

	   sub decode {
	       ...
	   }

	   sub encode {
	       ...
	   }

	   sub upgrade {
	       ...
	   }

	   sub decode_fields_ref {
	       ...
	   }

	   sub encode_fields_ref {
	       ...
	   }

DESCRIPTION

       This module is used by Text::CSV::Encoded internally.

INTERFACS

   decode
	   ( $self, $encoding, $str ) = @_;
	   ....
	   return $decoded_str;

       Takes an encoding and a CSV string.  It must return a Perl string decoded in $encoding.	In Perl 5.8 or later, if $enc is "undef" or false,
       the encoding should be utf8.

   encode
	   ( $self, $encoding, $str ) = @_;
	   ....
	   return $encoded_str;

       Takes an encoding and a Perl string.  It must return a CSV string encoded in $encoding.	In Perl 5.8 or later, if $enc is "undef" or false,
       the encoding should be utf8.

   decode_fields_ref
	   ( $self, $encoding, $arrayref ) = @_;

       Takes an encoding and an array reference.  It must decoded each array entries in $encoding.

   encode_fields_ref
	   ( $self, $encoding, $arrayref ) = @_;

       Takes an encoding and an array reference.  It must encoded each array entries in $encoding.

   upgrade
	   ( $self, $str ) = @_;

       In Perl 5.8 or later, it is expected to do "utf8::upgrade" against $str.  In older versions, this method may be meaningless and there is no
       need to implement.  See to utf8.

   encode_check_value
       Setter/Getter for an argument passing to encode.

	   $coder->encode_check_value( Encode::FB_PERLQQ );

   decode_check_value
       Setter/Getter for an argument passing to decode.

	   $coder->encode_check_value( Encode::FB_PERLQQ );

EXAMPLE

       Use with Jcode.

	   package Text::CSV::Encoded::Coder::Jcode;

	   use strict;
	   use base qw( Text::CSV::Encoded::Coder::Base );

	   use Jcode ();

	   my $Jcode = Jcode->new;

	   my %alias = (
	       'shiftjis' => 'sjis',
	       'euc-jp'   => 'euc',
	       'sjis'	  => 'sjis',
	       'euc'	  => 'euc',
	   );

	   sub decode {
	       my ( $self, $encoding, $str ) = @_;
	       my $enc = $alias{ $encoding };
	       $Jcode->set( $str, $enc )->euc;
	   }

	   sub encode {
	       my ( $self, $encoding, $str ) = @_;
	       my $enc = $alias{ $encoding };
	       $Jcode->set( $str, 'euc' )->$enc();
	   }

	   sub decode_fields_ref {
	       my ( $self, $encoding, $arrayref ) = @_;
	       my $enc = $alias{ $encoding };
	       for ( @$arrayref ) {
		   $_ = $Jcode->set( $_, $enc )->euc;
	       }
	   }

	   sub encode_fields_ref {
	       my ( $self, $encoding, $arrayref ) = @_;
	       my $enc = $alias{ $encoding };
	       for ( @$arrayref ) {
		   $_ = $Jcode->set( $_, 'euc' )->$enc();
	       }
	   }

AUTHOR

       Makamaka Hannyaharamitu, <makamaka[at]cpan.org>

COPYRIGHT AND LICENSE

       Copyright 2008-2010 by Makamaka Hannyaharamitu

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2010-04-26				      Text::CSV::Encoded::Coder::Base(3pm)

Shell Programming and Scripting