Solved

Format / convert string -> people

  • 9 February 2022
  • 3 replies
  • 8 views

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



 

icon

Best answer by mai-kel 2 March 2022, 09:46

View original

3 replies

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 🙂

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

KUDOS! I could not give it via button (max kudos reached - wtf?!?)

Reply