Solved

Set value of a single line text field from value of multiple line text field

  • 15 October 2015
  • 2 replies
  • 12 views

Badge +3

I have a multiple line text field in sharepoint list, its value is very long. I was trying to copy the first 50 letters from the multiple line field into a single line text field.

I created a simple workflow and have an action called Set Field in Current Item and it just doesn't work. It never pass that action.

 

Any idea on this issue.

 

Thank you in advance.

 

Alex

icon

Best answer by christopheraucq 15 October 2015, 10:18

View original

2 replies

Badge +9

Hi Alex,

You need a Regular Expression Action followed by a Extract Substring from Start of String action and finally a Set Field in Current Item action.

1. Regular Expression to Remove HTML Tags contained in the Multiple Line text: Source

The pattern is: <[^>]*>

2. Extract Substring from Start of String to get 50 first characters from Multipel Line

3. Set Field in Current Item to set Single Line Text: Target

Hope it helps

Christophe Raucq

Badge +3

Christophe,

It is exact what I was looking for in the last a couple days. Thank you so much!

Alex

Reply