teowt

How to split string at specified delimiter/separator in Nintex Workflow for Office 365?

Blog Post created by teowt Employee on Feb 12, 2015

A tricky & alternative solution to split string at specified delimiter.


Thanks to KuanChiang Lui to provide this Trick.

 

Scenario: There have a string value (Delimiter strings) that returned from a data source or response value from a web request (SOAP or REST) and would like to split it and store into a dictionary.

 

Example Input

Text = “1,2,3,4,5,6,7,8,9,10”

 

Expected Output

Dictionary = ["1","2","3","4","5","6","7","8","9","10"]

 

Solutions: Check out the step by step below.

Pre-requisites: Create a Text Variable and set value with "1,2,3,4,5,6,7,8,9,10".

{Variable: String to Split} = 1,2,3,4,5,6,7,8,9,10

 

Step 1: Apply “Set Workflow Variables” action and configure to add XML node in between “String to Split”.

 

Step 2: Apply “Replace Substring in String” action and configure to replace the delimiter “,” with XML node.

The Output “String to Split” is becomes a valid XML as below.

<values>

                <value>1</value>

                <value>2</value>

                <value>3</value>

                <value>4</value>

                <value>5</value>

                <value>6</value>

                <value>7</value>

                <value>8</value>

                <value>9</value>

                <value>10</value>

</values>

 

Step 3: Apply “Query XML” action and configure to query the values into dictionary.

 

Result: Return the string in dictionary format

{Variable: Output in Dictionary} = ["1","2","3","4","5","6","7","8","9","10"]


The enclosed attachment is the sample workflow that has been configured with steps above. You can import to Site workflow in Nintex Workflow Office 365.

 

Cheers!!!

Attachments

Outcomes