change in email replace @ to %
-
Saturday, February 09, 2013 8:06 AM
hi
I have an column named as Email
now i have its value in other column Email2
where the difference is only
abc@gmail.com where it replace @ to %
i.e abc%gmail.com in email2 kindly help.
- Changed Type Kalman TothMicrosoft Community Contributor, Moderator Saturday, February 09, 2013 1:05 PM question
All Replies
-
Saturday, February 09, 2013 8:18 AM
Hi! If you are asking how to replace "@" with "%" then you could use
replace('abc@gmail.com', '@', '%')
- Edited by Alexander Karavaev Saturday, February 09, 2013 8:18 AM
- Proposed As Answer by Naomi NMicrosoft Community Contributor, Moderator Sunday, February 10, 2013 3:59 AM
- Marked As Answer by Naomi NMicrosoft Community Contributor, Moderator Monday, February 11, 2013 2:35 PM
-
Saturday, February 09, 2013 9:02 AM
Try:
Replace(Email,'%','@')
Many Thanks & Best Regards, Hua Min
-
Monday, February 11, 2013 5:15 AMmany thanks .. it works..:)
.png)
