How to remove quotation marks using Formula
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-04-21 04:13 AM
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.
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-04-21 10:53 AM
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.
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
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-04-21 04:56 AM
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?
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?
