cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove quotation marks using Formula

John_GilbertDu1
Level 3
Hi, 

was there a way to  remove quotation marks using Formula from DFDs?

I tried using the STRREPLACE(FT_1_USER_FIELD,""","") but this doesn't work as the syntax is invalid. 
I tried using regex but the accuracy of the value captured is inconsistent. 

2 REPLIES 2

BenLyons
Staff
Staff
Hi John,

Have you tried adding them to the "Excluded Values" column?

Sorry, I don't have an example on hand to test this idea, but could create one if this doesn't work.
Ben Lyons Senior Product Specialist - Decipher SS&C Blue Prism UK based

HarpreetKaur
Level 7
Hi John,

Is it possible to get the values as is (with quotes) and remove them in your blue prism solution using a TRIM calculate stage for the value?