in reply to Re^2: Using Perl and WriteExcel to split data from one column to many others
in thread Using Perl and WriteExcel to split data from one column to many others

I get the funny feeling your 'first column' is just a string like this "(a, b, c, d)" (but I might be wrong, as I am new at this) If that is the case, removing the parentheses and then splitting on the comma will fix your issue:

my $set = $res[0]; #I use a lot of 'extra' variables to tell me what everything is $set =~ s/[\(\)]//g; #remove all parentheses my @values = split(',', $set); #now every value should have its own spot in the array

I hope this solves your problem.

Please ignore me if this is a stupid answer...

  • Comment on Re^3: Using Perl and WriteExcel to split data from one column to many others
  • Download Code

Replies are listed 'Best First'.
Re^4: Using Perl and WriteExcel to split data from one column to many others
by squarez (Initiate) on Oct 03, 2012 at 17:58 UTC
    Thank you for the help, went with your solution as it proved very quick :)