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

Also thank you for the help. I am currently thinking of:

while ($res[$o] = $sth->fetchrow_array()) {
    <code for splitting current array segment, and then printing the c
+orresponding splits into the next columns sequentially.>
}
[download]

I am thinking possibly another loop with an array to populate each rows values, then writing within that sub loop to each row column.

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

Replies are listed 'Best First'.
Re^3: Using Perl and WriteExcel to split data from one column to many others by Anique (Acolyte) on Oct 03, 2012 at 08:01 UTC
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` [download] I hope this solves your problem. Please ignore me if this is a stupid answer...	[reply] [d/l]
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 :)	[reply]