Find and Replace a name with an email, why is 2 being appended to my email?

[wonka1234]

hi,

I have the following data, 

Find		Becomes
Name		Email
Stevens, Louis A
Lou Stevens		LouisA.Stevens@hotmail.com
Louis Stevens		Louis.Stevens2@hotmail.com
Replace
c_Name	c_Email
Lou Stevens	LouisA.Stevens@hotmail.com

why is Louis.Stevens2@hotmail.com being created here? maybe im missing something in my setup, no clue how that is being picked up...

[JamesCharnley]

Hey @wonka1234 

Have you tried ticking the box that says 'Match Whole Word Only' or finding the Entire Field? Since they're so similar it seems like a reasonable place to start

[wonka1234]

Yes - still gives the Louis.Stevens2@hotmail.com

[JamesCharnley]

@wonka1234  sounds like unusual behaviour. Is it definitely happening in the find and replace? I can't recreate and haven't seen it before

[wonka1234]

Yes ive checked before that tool.. there is no Louis.Stevens2@hotmail.com prior.. its so confusing.

[JamesCharnley]

@wonka1234  could there be a row you've not seen somewhere in the Replace anchor with Louis Stevens in? I'm  pretty much out of suggestions without being able to see it