[Solved] Perl Question - split function with csv file

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl split function

my @d =split('\|', $_); west|ACH|3|Y|LuV|N||N|| Qt|UWST|57|Y|LSV|Y|Bng|N|KT| It Returns d as 8 for First Line, and 9 as for Second Line . I want to Process Both the Files, How to Handle It.

2. UNIX for Advanced & Expert Users

regular expression for split function in perl

Hi, Below is an example of a record I have, which I wish to split using the perl's split function and load it into an array. I am having tough time figuring out the exact reg-ex to perform the split. Given record: "a","xyz",0,2,48,"abcd","lmno,pqrR, stv",300,"abc",20, The delimiter to...

3. Shell Programming and Scripting

Perl int function solved

Hello, I have the below perl function int to return the integer value from the expression but it is not. I am not sure if something misses out here. Any help on this? Thanks in advance. # Code sample Start my $size = int (`1134 sample_text_here`); print "$size \n"; # Code end ----------...

4. Programming

split xlsx to csv using perl

Hi, I am new to perl. I want to split excel 2007 file to csv. every formula should be evaluated on each field. Plz help me

5. Shell Programming and Scripting

PERL split function

Hi... I have a question regarding the split function in PERL. I have a very huge csv file (more than 80 million records). I need to extract a particular position(eg : 50th position) of each line from the csv file. I tried using split function. But I realized split takes a very long time. Also...

6. Homework & Coursework Questions

PERL split function

7. Homework & Coursework Questions

PERL split function

8. Shell Programming and Scripting

perl-like split function for bash?

Hi! I'm doing bash shell scripting and would like to know if bash had something similar to perl's split function? Ultimately, I want to split two strings (delimeter = '.') and compare each of their values. Thus, I figured putting them in an array would be easiest. So i.e.: String 1:...

9. Shell Programming and Scripting

Use split function in perl

Hello, if i have file like this: 010000890306932455804 05306977653873 0520080417010520ISMS SMT ZZZZZZZZZZZZZOC30693599000 30971360000 ZZZZZZZZZZZZZZZZZZZZ202011302942311 010000890306946317387 05306977313623 0520080417010520ISMS SMT ZZZZZZZZZZZZZOC306942190000 30971360000...

10. Shell Programming and Scripting

perl split function

$mystring = "name:blk:house::"; print "$mystring\n"; @s_format = split(/:/, $mystring); for ($i=0; $i <= $#s_format; $i++) { print "index is $i,field is $s_format"; print "\n"; } $size = $#s_format + 1; print "total size of array is $size\n"; i am expecting my size to be 5, why is it...

LEARN ABOUT DEBIAN

text::csv::encoded::coder::encodeguess

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

NAME

       Text::CSV::Encoded::Coder::EncodeGuess - Text::CSV::Encoded coder class using Encode::Guess

SYNOPSIS

	   use Text::CSV::Encoded  coder_class => 'Text::CSV::Encoded::Coder::EncodeGuess';
	   use Spreadsheet::ParseExcel;

	   my $csv = Text::CSV::Encoded->new();

	   $csv->encoding( ['ucs2', 'ascii'] ); # guessing ucs2 or ascii?
	   $csv->encoding_to_combine('shiftjis');

	   my $excel = Spreadsheet::ParseExcel::Workbook->Parse( $file );
	   my $sheet = $excel->{Worksheet}->[0];

	   for my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) {
	       my @fields;

	       for my $col ( $sheet->{MinCol} ..  $sheet->{MaxCol} ) {
		   my $cell = $sheet->{Cells}[$row][$col];
		   push @fields, $cell->{Val};
	       }

	       $csv->combine( @fields ) or die;
	       print $csv->string, "
";
	   }

DESCRIPTION

       This module is inherited from Text::CSV::Encoded::Coder::Encode.

USE

       Except for 2 attributes, same as Text::CSV::Encoded::Coder::Encode.

   encoding_in
	   $csv = $csv->encoding_in( $encoding_list_ref );

       The accessor to an encoding for pre-parsing CSV strings.  If no encoding is given, returns current $encoding, otherwise the object itself.

	   $encoding_list_ref = $csv->encoding_in()

       When you pass a list reference, it might guess the encoding from the given list.

	   $csv->encoding_in( ['shiftjis', 'euc-jp', 'iso-20022-jp'] );

       If it cannot guess the encoding, the first encoding of the list is used.

   encoding
	   $csv = $csv->encoding( $encoding_list_ref );
	   $encoding_list_ref = $csv->encoding();

       You can pass a list reference to this attribute only:

	 * For list data consumed by combine().
	 * For list reference returned by getline().

       In other word, in "combine" and "print", it might guess an encoding for the passing list data.  If it cannot guess the encoding, the first
       encoding of the list is used.

SEE ALSO

       Encode, Encode::Guess

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::EncodeGuess(3pm)

UNIX for Dummies Questions & Answers