Hi folks,
Attempting to loop through a SQL selected array of XML values to perform IGL web service calls. The structure of an individual XML block is as follows:
<AccountChange>
<operation>Disable</operation>
<businessSource>Active Directory</businessSource>
<account>CN=TestUser,OU=TestOU,DC=test,DC=com</account>
</AccountChange>
When I feed this array into a Next Value node, it splits by default on the comma character - this results in splitting the above XML into:
[<AccountChange><operation>Disable</operation><businessSource>Active Directory</businessSource><account>CN=TestUser],
[OU=TestOU],
[DC=test],
[DC=com</account></AccountChange>]
Is there a way to amend the Next Value node delimiter? If so, I could make sure to append my selected values with the delimiter character which I could be confident would not exist in the string.
Cheers,
Alex.
Hi,
An array [] in always splited by the comma.
For you needed, your value should be surround by apostrophe I guess to not being understood to being split. This is our we do for playing with string containing a comma in an array.
['String, 1', 'String, 2']