Eclipse Community Forums: BIRT » Split by data separated by blank space

Home » Archived » BIRT » Split by data separated by blank space

Split by data separated by blank space [message #1646990]

Tue, 03 March 2015 02:45

Eclipse User

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 17:47

Eclipse User

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 11:51

Eclipse User

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.

Attachment: DynamicTable.rptdesign
(Size: 13.87KB, Downloaded 399 times)

Re: Split by data separated by blank space [message #1661101 is a reply to message #1652018]

Mon, 09 March 2015 09:32

Eclipse User

Thank You very much Smile

Previous Topic:	Newbie - Reading in data basics
Next Topic:	BIRT 4.4.2 OSGi on JBoss 6

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Mar 25 15:37:24 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter