Community

My string looks like this

XXX1 Submited By Francis 2 ( xxxxxx @ hotmail . com ) XXX2
XXX1 Submited By Francis 1 ( xxcxxx @ gmail . com ) XXX3

I can find Submited By but how do I select up to )

I'd like to be left with
XXX1*XXX2
XXX1*XXX3

THanks
Steve

Find what:

Submited By.*)

With regular expression enabled and POSIX regular expression syntax enabled in the general preferences.

Please note there is a space in front of 'Submited By'. The '.' character indicates find any character and the '*' means repeated zero or more times and then the search strings ends on the ')'

There are other ways to do this but this seems to fit in with the search you've already described.

I wasn't sure whether your 'X' and '*' characters indicated variable content here.

Hope this helps.

SteveH wrote:Find what:

Submited By.*)

With regular expression enabled and POSIX regular expression syntax enabled in the general preferences.

Please note there is a space in front of 'Submited By'. The '.' character indicates find any character and the '*' means repeated zero or more times and then the search strings ends on the ')'

There are other ways to do this but this seems to fit in with the search you've already described.

I wasn't sure whether your 'X' and '*' characters indicated variable content here.

Hope this helps.

Thanks
That is what I needed - for some reason I thought ) was a reserved character.

Search for: ^(XXX1).*(XXX[0-9])$
Replace with: \1*\2

Converts from this:
XXX1 Submited By Francis 2 ( xxxxxx @ hotmail . com ) XXX2
XXX1 Submited By Francis 1 ( xxcxxx @ gmail . com ) XXX3

To this:
XXX1*XXX2
XXX1*XXX3



Use the following settings:
-----------------------------------------
[X] Regular expression
Replace All
-----------------------------------------
Configure | Preferences | Editor
[X] Use POSIX regular expression syntax
-----------------------------------------