Start a new topic

Using Regex to replace "And" with "&"

Hello.  I would like to use Regex to replace all occurrences of "And" or "and" with "&" when used between two names in the first name field.

When I use a simple solution, it also replaces any string of "and" ... for example:  Landon would be replaced with L&on

 

Is there a way to have it look for "space and space" so it will not replace any string of and?  I'm sure this is easy but I'm stumped.


I have resolved this issue ... if anyone has a similar scenario, please let me know and I can share the solution.

Please send me the solution and thanks.

Login or Signup to post a comment