topic How to remove quotation marks using Formula in Product Forum

How to remove quotation marks using Formula

John_GilbertDu1 — Tue, 13 Apr 2021 03:13:27 GMT

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.

Re: How to remove quotation marks using Formula

Ben.Lyons1 — Tue, 13 Apr 2021 09:53:25 GMT

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.

Re: How to remove quotation marks using Formula

HarpreetKaur — Mon, 19 Apr 2021 03:56:17 GMT

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?