Skip to main content
Nintex Community Menu Bar
Solved

K2 Five Workflow SharePoint - Split function on Multi line Text field Newline

  • July 24, 2019
  • 2 replies
  • 110 views
  • Translate

Hello -

 

I have a SharePoint Multi-line text area (plain text) that users enter 1 value per line...

 

Is it possible to use the K2 Five workflow split function with the separator being the newline vs. a character ( ; or | )?

 

If so, what would the newline representation be?  
...
... or a chr(XXX) value?

 

Thanx !!

 

Jeff

Best answer by Albarghouthy

Hi,


 


I use the following functions to replace new lines in Forms,  I believe it would be the same in your case:


 


Url Decode ( Replace ( Url Encode ( Text ) , %0A, ReplaceCharacter) )


Then you can wrap the whole function with Split 


 


I haven't tested it, please let me know the results


 

View original
Did this topic help you find an answer to your question?

2 replies

Albarghouthy
Forum|alt.badge.img+16
  • Scholar
  • 741 replies
  • Answer
  • July 24, 2019

Hi,


 


I use the following functions to replace new lines in Forms,  I believe it would be the same in your case:


 


Url Decode ( Replace ( Url Encode ( Text ) , %0A, ReplaceCharacter) )


Then you can wrap the whole function with Split 


 


I haven't tested it, please let me know the results


 

Translate

  • Author
  • 11 replies
  • July 24, 2019

Hello !

 

Thank you for the suggestion and the coaching!

 

I took it step by step using variables inside the workflow to verify and it worked great!

 

Only chanage was to use %0a vs %0A

 

See attached screen shot


Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings