Regular Expression, return after each item

  • 17 March 2020
  • 3 replies
  • 4 views
I
Badge +3

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).

 

3 replies

K
Badge +12

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

SimonMuntz
Userlevel 6
Badge +22
I suggest using a build string instead of a Regular expression.
Cool Nintex courses: https://learn.nintex.com/
I
Badge +3

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

6865iA6C9F51D73F89D1F.png

 

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

6863iE43BC5237998C914.png

 

Step 3: Regular Expression 1

6864iB44E7E701E643AB8.png

Step 4: Regular Expression 2

6866i65C55B0291B680D2.png

Step 5: Repeat until you have all columns

Step 6: Build a string

6867iCD4AC0ADA00D335B.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:

 

 

6862iAFB89EF79D95ACD3.png

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings