I have a string:
<IncomeLossUSPartnerships referenceDocumentId="PartnerIntM30004RIC1">
I'd like to delete the text within the quotations:
<IncomeLossUSPartnerships referenceDocumentId="">
What would be the best way to do this?
@lipster26 I would use regex in a formula tool:
Regex_replace([Field1],'".*"','""')
There’s quite a few ways to achieve this, personally, I would go the RegEx route as use a statement like...
RegEx_replace([Field],’”\w+”’,’””’)
which means replace any instance of alphanumeric characters contained within double quotes with double quotes.
Another way would be to use a text to columns tool, splitting on the double quotes character and then reconstructing your string after with a formula tool, which may be easier for someone looking at your workflow to consume.
Ben