Skip to main content
Nintex Community Menu Bar
Solved

Format / convert string -> people

  • February 9, 2022
  • 3 replies
  • 104 views
M
Forum|alt.badge.img+10

Hi there,

 

this should be a simple task but somehow I have problems.

Due to a lookup to a people picker field (multiple persons possible) on a form, I receive the following (back):

[37;#Lucas, Philipp (EXT),86;#Weiss, Michael (EXT),87;#Weiss, Michael (EXT)]

 

I need those people as recipients of a flexi task.

So, how do I get

THIS: Lucas, Philipp (EXT);Weiss, Michael (EXT);Weiss, Michael (EXT)

OUT OF THIS: [37;#Lucas, Philipp (EXT),86;#Weiss, Michael (EXT),87;#Weiss, Michael (EXT)]

 

PS: I am clueless concerning RegEx - I tried but my brain cannot. 

 

Please help.

 

Cheers

mai-kel

 

Best answer by mai-kel

I did it by myself in the meantime, I need four steps (better to process for my little brain. 🙂

ersetzen = replace

 

 

 

 

Hope this helps.

 

Cheers

mai-kel

    3 replies

    M
    • Mary29
    • February 11, 2022

    Hi Mai-kel,

    you need to do it in two steps, first extract the strings based on hashtag:

    then get rid of extra comma (note: unfortunately, comma is in your case both delimiter and part of the sub-string you want to extract)

     

    Hope it helps 🙂

    M
    Forum|alt.badge.img+10
    • mai-kel
    • Author
    • Rookie
    • Answer
    • March 2, 2022

    I did it by myself in the meantime, I need four steps (better to process for my little brain. 🙂

    ersetzen = replace

     

     

     

     

    Hope this helps.

     

    Cheers

    mai-kel

    M
    Forum|alt.badge.img+10
    • mai-kel
    • Author
    • Rookie
    • March 2, 2022
    KUDOS! I could not give it via button (max kudos reached - wtf?!?)
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement