AnsweredAssumed Answered

Extract Substring using Regular Expression

Question asked by lfumhm on Nov 9, 2015
Latest reply on Nov 10, 2015 by cju@evolusys.ch

I used a formula to extract comments from Lazy Approval. I tested by clicking run now from workflow, it work fine.

For example, I manually entered Input text as

-----------------------------------------------------------------------------------------

(John, Smith) LazyApproval by test@test.com  Test

no

From: sharepoint@test.com [mailto:sharepoint@test.com]

Sent: Monday, November 09, 2015 12:15 PM

To: John, Smith

Subject: Please review Request [#BBBYZZ#]

-----------------------------------------------------------------------------------------

It returned me as "(John, Smith) LazyApproval by test@test.com  Test  no"

 

However, since I have to store the results as a collection, after regular expression, I only got no inside my collection. I looped through the collection, only one value which is no was found. I don't know where's the other strings?

 

Thanks a lot!

Outcomes