Hi,
1) I am getting data like this in a field customer name. I am manually doing name and email fields by cut and paste and delete etc.
abcd exacfareasa
(abcd.exacfareasa@xyatdns.com)
(sip:abcd.exacfareasa@xyatdns.com)
I wanted to write a function it should trim data like
Name email
abcd exacfareasa
abcd.exacfareasa@xyatdns.com