cancel
Showing results for 
Search instead for 
Did you mean: 
imflowers
Nintex Newbie

Regular Expression, return after each item

Jump to solution

Hello!

I am learning Repeating Section, and I finally got to the point where my XML finally looks like:

cat 0103/27/2020 00:00:00is gray;cat 0203/13/2020 00:00:00is white;;
I would like it to look like:
cat 01
03/27/2020 00:00:00
is gray;
cat 02
03/13/2020 00:00:00
is white;;
I am using Regular Expression but I can't figure out how to insert a break at the end of each Item.
Thank you (very new to Nintex).

 

Labels: (1)
Tags (1)
0 Kudos
Reply
3 Replies
kunalpatel
Automation Master
Automation Master

Re: Regular Expression, return after each item

Jump to solution

@imflowers .....what's the source of your XML?

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Regular Expression, return after each item

Jump to solution
I suggest using a build string instead of a Regular expression.
0 Kudos
Reply
imflowers
Nintex Newbie

Re: Regular Expression, return after each item

Jump to solution

Thank you for all your comments. I had help from one of our developers yesterday. In case someone new to Nintex ever finds him/herself lost in the wonderful world of XML, here is how it's done:

Step 1: Grab the XML at the items level

im_02.png

 

Step 2: For each: Store Collection in Single Line of text var

im_03.png

 

Step 3: Regular Expression 1

im_04.png

Step 4: Regular Expression 2

im_05.png

Step 5: Repeat until you have all columns

Step 6: Build a string

im_06.png

Step 7: Update the column

 

The result will look like:

 

Manual Update: Cat 01

Manual Update Date: 03/27/2020

Manual Update Notes: is gray

 

Here is what the workflow looks like:

 

 

im_01.png

View solution in original post

0 Kudos
Reply