Split a String with separator in multiple rows

[gadje1]

Hi everyboby,

I would like be able to split a String with @ separator like that :

ORxxx@ORxxx@ORxxx

in multiple rows like that :

ORxxx

ORxxx

ORxxx

Is there a simple way to do it ?

Here'is a sample of my input csv file :

OR00617441@

OR00595880@OR01018483@

OR00595875@

OR00617442@OR02458307@OR02413721@

OR00595879@

OR02413716@

OR00595864@

OR00075148@

OR00595863@

OR00595860@OR00595865@OR02457921@OR00595861@OR00595866@OR02457922@OR00595862@OR00595867@OR02457923@

Thanks in advance

[Prakhar1]

okay no problem

[gadje1]

I am close to the solution but i don't recover all the split values, for the lines i have to split like those as shown below in my CSV entry :

i maked a routine that split my strings with a @ separator as shown below :

This is my job structure and the routine that i calling :

Everything's ok in console view, i catch both tokens corresponding at the above example :

But not in my csv file output, i just catch the second token of my splited line

Is there somebody who knows why ??

Thanks in advance.