Problem building message body based on the numbers of Vendors
Hi all,
(Sorry to repeat this but marked my last post as answered) I have a message which contains a header body & trailer, based on the amount of vendors in my <Body> I would like to split the message into 20 lines per message.
Ie.
<Header>
Line1
Line 20
<Trailer>
I have an expression doing a xpath count of the number of lines in the body and then I go into a loop and count them all. From here I have a decide shape that filters them off based on the amount of vendors if (nLoopCount <= 30)
Then I build the message in an expression shape as below
MyVar = MyVar + “<BACSBody>”+sbRemitMsg.ToString()+”</BACSBody>”;
RemitXmlDoc.LoadXml(strHeaderRemitMsg + MyVar + strTrailerRemitMsg);
This does some of what I need but if I have 30 vendors return it repeats the below 30 times one after another.
Do I have to build say the first 30 into an xml document and do the same for the rest of them?
<Header>
Line1
Line 20
<Trailer>
<Header>
Line1
Line 20
<Trailer>
Can anyone tell me where I am going wrong please
Kind Regards
Grant