I want to replace the string that starts with " (5" and has 7 characters and ends with ")"
e.g. " (5??????) "
Thanks,
Solved! Go to Solution.
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 ?
Adding examples for what @cmcclellan suggested:
REGEX_Replace([Field1], '\(5.{7}\)', 'NewText')
Or, if you want to use the RegEx tool:
It worked, Thank you