replace the string using wild card

[Payal1]

I want to replace the string that starts with " (5" and has 7 characters and ends with ")"

e.g. " (5??????) "

Thanks,

[cmcclellan]

You can use the REGEX_REPLACE function in a formula tool, or the RegEx tool itself

When you find (5??????) what do you want to replace it with ?

[danrh · Accepted solution]

Adding examples for what @cmcclellan suggested:

REGEX_Replace([Field1], '\(5.{7}\)', 'NewText')

Or, if you want to use the RegEx tool:

[Payal1]

It worked, Thank you