Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Split by data separated by blank space
Split by data separated by blank space [message #1646990] Tue, 03 March 2015 07:45 Go to next message
pierre diaz is currently offline pierre diazFriend
Messages: 2
Registered: March 2012
Junior Member
Hello
Could you tell me how, for each line, cut the line in terms of space and put each value on another line

My table:
ID ANOMALIES
3903 B1 D1 CAT1
3904 D7 D2 B1 CAD4

I would like to:
ID ANOMALIES
3903 B1
3903 D1
3903 CAT1
3904 D7
3904 B1
3904 D2
3904 CAD4

but I have a lot of difficulties with the declaration and use table
Could you help me?

Thank You, have a nice day
Pierre
Re: Split by data separated by blank space [message #1650590 is a reply to message #1646990] Wed, 04 March 2015 22:47 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Instead of trying to dynamically modify the table, it would be better to do this earlier on so your data set is already configured with the desired row/column setup.
I would recommend doing this Database side first. Otherwise, I would recommend creating a scripted data set.
Re: Split by data separated by blank space [message #1652018 is a reply to message #1650590] Thu, 05 March 2015 16:51 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
For reference, this can be achieved through scripting by dynamically creating the table.

Attached is a sample report that demonstrates dynamically creating a table with your desired logic of splitting the second column into multiple rows based on spaces.

Keep in mind, you should still try and have the data set built with your desired structure, as I indicated above, instead of dynamically creating a table.
Re: Split by data separated by blank space [message #1661101 is a reply to message #1652018] Mon, 09 March 2015 13:32 Go to previous message
pierre diaz is currently offline pierre diazFriend
Messages: 2
Registered: March 2012
Junior Member
Thank You very much Smile
Previous Topic:Newbie - Reading in data basics
Next Topic:BIRT 4.4.2 OSGi on JBoss 6
Goto Forum:
  


Current Time: Mon Jul 22 14:24:52 GMT 2024

Powered by FUDForum. Page generated in 0.19477 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top