Splitting a concatenated string to multiple cells in a row in BIP Reports

10-11  Source: Network gathering  Views:1 

Hello Experts,
Let me how to split a concatenated string into multiple cells in BIP reports rtf.
string: acg;ghdf;tesrlkjj;hvfffda
has to placed in multiple cells like
string1: acg
string2: ghdf
string3: tesrlkjj
string4: hvfffda
Appreciate your quick reply.
Please drop in the pseudo code.
Thanks & Regards
The report is based on a standard sql query such as
select item1, item2, item3, item4, item5, item6, item7
from mytable
order by item1Wanted to put that in as I am not using an interactive report.
Related articles