Hi All,
I need to extract specific information from a field in a table which looks like the following;
Jim (jim@someone.com)
Basically I need to extract the email part; jim@someone.com.
Obvioulsy the length of the field is going to be different and is dependant on the persons name, i.e. it could look the following;
James (james@someone.com)
Any suggestions?
Thanks in advance
I need to extract specific information from a field in a table which looks like the following;
Jim (jim@someone.com)
Basically I need to extract the email part; jim@someone.com.
Obvioulsy the length of the field is going to be different and is dependant on the persons name, i.e. it could look the following;
James (james@someone.com)
Any suggestions?
Thanks in advance