I have some values in a fied which are email addresses.
eg: Values of F may be
"[""email_type2@gmail.com""]"
"[""email_type1@gmail.com"",""email_type2@hotmail.com""]"
"[""email_type1@live.com"",""email_type2@aol.com"",""email_type3@outlook.com""]"
The field F may have 1, 2 or 3 values. If there is only 1 value, it is going to be email_type2, if there are 2 values it will be email_type1 followed by email_type2 and if there are going to be 3 values, it is going to be email_type1 followed by email_type2 and email_type3.
I need to extract 3 fields, type1, type2 and type3 and include those values in the extracted fields. Can someone help me with this?
... View more