Search code examples
xmlbiztalkbiztalk-2013biztalk-mapper

BizTalk Map Cumulative String Functoid

I have an issue with a BizTalk map whereby I need to copy the data from the source schema to the destination schema, but with a condition.

I want to copy the values in 3 nodes with the same name, with the exception of one value. Let me explain better.

Given the example:

<testxml>
    <node>abc</node>
    <node>def</node>
    <node>ghi</node>
    <node>jkl</node>
</testxml>

Using String concatenation, I managed to get the data on the destination schema to the following:

<testxml>
    <node>abcdefghijkl</node>
</testxml>

However I want the output to be similar to the following:

<testxml>
    <node>abcdefjkl</node>
</testxml>

Therefore I am extracting the values 'ghi' from the output.

Is there any way I can achieve this?

Note: I cannot use String Extract as the text I need to extract is in the middle of the string

Solution

  • Here is the "cleanest" solution (be carefull the script functoid is dangerous since it causes memory leaks in some situations like big files you must use it only in extreme cases more details are available here https://support.microsoft.com/en-us/kb/918643), now for your problem you can do this just by combining the not equal operator (where you tell basically that your element should not be equal to JKL or whatever) then add a cumulative concatenate functoid and you will have in your output all your strings concatenated except the one that shouldn't

    enter image description here

    You can find in the attachment a little sample i made Sample Demo