<?xml version="1.0" encoding="windows-1252"?>
<node id="997001" title="Re^3: Using Perl and WriteExcel to split data from one column to many others" created="2012-10-03 04:01:30" updated="2012-10-03 04:01:30">
<type id="11">
note</type>
<author id="994929">
Anique</author>
<data>
<field name="doctext">
&lt;p&gt;
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:&lt;/p&gt;

&lt;p&gt;&lt;code&gt;
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
&lt;/code&gt;&lt;/p&gt;

&lt;p&gt;
I hope this solves your problem.&lt;/p&gt;
&lt;p&gt;Please ignore me if this is a stupid answer...&lt;/p&gt;</field>
<field name="root_node">
996936</field>
<field name="parent_node">
996952</field>
</data>
</node>
