Map 2 bundles to one line of the text aggregator

How To
,
1

the input IFC File is already transfered to a csv/text file to intepret the data. My goal is to transfer it into xml structure.

My content have a few thousand lines and there will be always the same structure which is important to me. Between these important structure are many lines which are not needed.

important structure:
#4713 = IFCPRODUCTDEFINITIONSHAPE($, $, (#4706));
#4707 = IFCFLOWFITTING(‘23imnoYoM4E6xAVmf1Mgnl’, #2, ‘linDbBogen’, ‘Bogen’, $, #4708, #4713, 'Tag:223366288’);
#4714 = IFCPROPERTYSINGLEVALUE(‘ARTICLE_NUMBER’, $, IFCTEXT(‘435639’), $);
#4715 = IFCPROPERTYSINGLEVALUE(‘SHORT_DESCRIPTION’, $, IFCTEXT(‘123456 Test’), $);
#4716 = IFCPROPERTYSET(‘0NGlS16kEi7sAAo_IbjxFc’, #2, ‘LINEAR Common’, $, (#4714, #4715));
#4717 = IFCDISTRIBUTIONPORT(‘07OF4yaq$ub2RFUtwAkJag’, #2, $, $, $, $, $, $);

I would like to transfer the important lines the following structure
Tag/ARTICLE_NUMBER/SHORT_DESCRIPTION
ag:223366288/435639/123456 Test
…

I already made an Text parser (match patterns) to get just the lines with IFCPROPERTYSINGLEVALUE (IFCPROPERTYSINGLEVALUE(‘([^’])‘, $, IFCTEXT(’([^'])'), $);). Here is my challenge to aggregate 2 bundles in one line of the text aggregator. Is it possible the create an Table/Array/Text Aggregator like
ARTICLE_NUMBER/SHORT_DESCRIPTION
Bundle(1).Value/Bundle(2).Value
Bundle(3).Value/Bundle(4).Value
…
?

Thanks a lot in advance

2

Hi @Wilhelm_Markett

You can attempt this by aggregate all the bundles using an array aggregator, which will create an array of bundles. Afterward, you can iterate through them and use a text aggregator accordingly.

For further implementation, please connect to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
3

Hi Msquare_Automation,

Thanks for your Reply.
I am looking for a smarter solution.

Aggregate from my array/bundles (45) each 5 results to one row.