AnsweredAssumed Answered

Regex extract producing extra characters in the results [" "]

Question asked by kevyn.williams@peluk.org on Jul 21, 2017
Latest reply on Aug 25, 2017 by kevyn.williams@peluk.org

Hi there,

 

I'm using a regex in a workflow to extract some text from a string, save it to a variable and then update a column with that variable (if it doesn't already match).

 

My regex:

(?<=-).+(?=-)

 

However when the column is updated, the value entered has [" "] around it - does anyone know why?

 

Original string:

RANDOMSTRING1 - RANDOMSTRING2 - RANDOMSTRING3

 

Regex (extract):

(?<=-).+(?=-)

 

Result:

[" RANDOMSTRING2 "] 

 

Any help greatly appreciated, example here: regex101

Outcomes