A ridiculous problem

This seems to me to be quite a ridiculous problem, but I can't find a way to solve it. I have an attribute that comes from an Apache 2.2.25 API connected through a HTTPFetcher that I need to split into a number of new attributes. This is an exapmle of the attribute with the kind of data it contains (alsways numbers of vaying lenght separated by "/"):

 

 

Attribute X

 

12345

 

12345/123456

 

12345/123456/12345

 

123456/12345

 

 

What I need is this result:

 

Attribute X                           AttributeNew1      AttributeNew2      AttributeNew3

 

12345                                 12345                    <blank>                 <blank>

 

12345/123456                  12345                    123456                  <blank>

 

12345/123456/12345      12345                    123456                 12345

 

123456/12345                   123456                  12345                   <blank>

 

 

What I get now is this:

 

Attribute X                           AttributeNew1      AttributeNew2      AttributeNew3

 

12345                                 <blank>                 <blank>                 <blank>

 

12345/123456                  123456                  <blank>                 <blank>

 

12345/123456/12345      123456                 12345                    <blank>

 

123456/12345                   12345                   <blank>                 <blank>

 

 

In other words, the splitter does not transfer the first value to a new attribute. I've been trying a lot of different approaches without any luck. Ant ideas on what to do?

 

 

Thank you!

 

 

Chris