Find and Replace text within quotations

[lipster26]

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?

[patrick_digan]

@lipster26 I would use regex in a formula tool:

Regex_replace([Field1],'".*"','""')

[BenMoss]

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

[Tyro_abc]

Hi @lipster26 

Try this ....

Best Regards

Arundhuti