right to left search/ find last instance

[jempie]

Hi all,

I have some records containing the following data

ABC (UK)
ABC (UK) Ltd
ABC UK) Ltd
ABC UK)

I need to pull out all the data with a ) but not a ( and add a ( to the start of the word before the ).

So for example, the four examples above would change to:

ABC (UK)
ABC (UK) Ltd
ABC (UK) Ltd
ABC (UK)

I have selected the companies that need updating, and I can pull the data to the left of the ), but I don't know how to find the first instance from right to left of " ", or find the last instance from left to right of " ".

Can anyone help?

Thanks.

 

[Bat17]

Have a look at instrrev() in help

Peter