waytoperl has asked for the wisdom of the Perl Monks concerning the following question:
Need to create a hash table from csv file. Starting from sample code's, I'm getting error. I don't know do i need to use hash_ref to recognize(add/modify) hash table. Hash table should contain contents of Column1 and Column5 from CSV file. Hash $keys need to be Column5 and corresponding $values to be Column1. Later, I'll refer/replace Column1 to edit other task. Please help me how to solve these task! Thanks
line 1 table description,,,,,,,, line 2 few more file describtion,,,,,,,, ,,,,,,,, ,,,,,,,, ,,,,,,,, ,,,,,,,, ,,,,,,,, Column_1,Column_2,,,,Column_3,Column_4,Column_5, Name11,In,,,,DATA13,DATA14,Id11, Name21,Out,,,,DATA23,DATA24,Id11, Name31,In,,,,DATA33,DATA34,Id22, Name41,In,,,,DATA43,DATA44,Id22, ,,,,, ,,,,, ,,,,,
sub mainCSV { open (my $inputfile1, '<', "$inputfile") or die "Unable to open $input +file1: $!"; my %hash; while (<$inputfile1>) { $inputfile1 =~ s/\s*\z//; my @arrayfile1 = split /,/, $inputfile1; my $keyfile1 = shift @arrayfile1; $hash{$keyfile1} = \@arrayfile1; } print %hash; close $inputfile1; }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: csv to hash table
by BrowserUk (Patriarch) on Nov 19, 2013 at 05:23 UTC | |
by waytoperl (Beadle) on Nov 19, 2013 at 05:41 UTC | |
by BrowserUk (Patriarch) on Nov 19, 2013 at 06:21 UTC | |
by waytoperl (Beadle) on Nov 19, 2013 at 09:10 UTC | |
by Corion (Patriarch) on Nov 19, 2013 at 09:18 UTC | |
by locked_user sundialsvc4 (Abbot) on Nov 19, 2013 at 14:56 UTC | |
| |
|
Re: csv to hash table
by kcott (Archbishop) on Nov 19, 2013 at 05:07 UTC | |
|
Re: csv to hash table
by 2teez (Vicar) on Nov 19, 2013 at 05:01 UTC | |
by waytoperl (Beadle) on Nov 19, 2013 at 05:18 UTC | |
by kcott (Archbishop) on Nov 19, 2013 at 05:46 UTC | |
by GrandFather (Saint) on Nov 19, 2013 at 20:18 UTC | |
by kcott (Archbishop) on Nov 20, 2013 at 06:18 UTC |