Want to get rid of only two special characters

[theamandagail]

Hello,

I only want to get rid of two special characters in every field of my output:

--

"

I currently have it set up where I have one formula for each field name. However, I want a formula for the whole output.

Can someone assist? It's cumbersome to do the same formula for each field name.

Replace([FEDERAL_TAX_ID],'--',' ')

Replace([ACRONYM],'--',' ')

etc.

[ChrisTX]

Use the Multi-field Formula tool

[ArtApa · Accepted solution]

I attached a workflow for your convenience.

[MarqueeCrew]

Sorry @ArtApa , but that answer will create problems for 3 or more -'s

Regex_Replace[_CurrentField_],"(.*?)--(.*)",'$1$2')

 cheers,

 mark

[theamandagail]

Thank you!

Does this formula go in the "Multi Row Formula" tool?

[theamandagail]

That worked! Thank you for all your help!