Skip to main content
Nintex Community Menu Bar

Regular Expression, return after each item

  • March 17, 2020
  • 3 replies
  • 19 views
Forum|alt.badge.img+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

    Forum|alt.badge.img+12
    • kunalpatel
    • Scholar
    • March 17, 2020

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

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • March 17, 2020
    I suggest using a build string instead of a Regular expression.
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Forum|alt.badge.img+3
    • imflowers
    • Author
    • Rookie
    • March 18, 2020

    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

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement