I have a column with names as 'BP Connect Ascot(WA)' and correctly as ''BP Bathurst (Stewart St)'
I want them to be consistent with a space before the bracket like 'BP Connect Ascot (WA)' and ''BP Bathurst (Stewart St)'
How can I do that?
Thanks
Solved! Go to Solution.
That is not the solution I am looking for as I have 'BP Bathurst (Stewart St)' coming in correctly which will turn out to 'BP Bathurst (Stewart St)' Which is not what I want.
Regex_Replace([field],"(.*\S)(\(.*)",'$1 $2')
It is doing nothing
@HW1
Sorry. I misunderstood. This should work.