Hi Guys,
I am doing data migration and don't have a clue on how to parse an email address. Your help is very much appreciated.
Here is what my data looks like
firstname_lastname@xxx.yyy.com firstname lastname
In my current table, I have one attribute called submitter which contains the email and name of the submitter as shown above. In my new table I have 2 attributes called Name, and email. Is there a way to write an expression in a select statement to break the email and name apart into 2 different attributes ??
Thanks a lot.