Split and Combine Delimited String

Scenario:

Expected Input: a,b,c

1. Split like below

<input>a</input>
<input>b</input>
<input>c</input>

2. Using DVM change a b c to A B C

<input>A</input>
<input>B</input>
<input>C</input>

3. Combine back as below

<input>A;B;C</input>

Expected Output: A;B;C

Solution:

Create a synchronous BPEL





Create XSD as below



Create three variables of type element with the use of above XSD



Drag drop an Assign activity and split the input delimited strings into multiple nodes using Advanced Function oraext:create-nodeset-from-delimited-string







As this is a Advanced function i.e., extension function add the below highlighted from source view



Transform the data from a given format to other format which end system is accepting using DVM







Drag drop an Assign activity and combine the splited notes into single nodeset using String Function oraext:create-delimited-string







Finally Assigning data in variable Var3 to result





Testing:

Input:



Output:

Thank You!!!!

Happy Learning!!!!