I have email addresses stored in a variable EMAIL of SAS data set. It is a free text field so user has given more than one Email address with various delimiter like space, comma, semicolon, colon and other. Below is the sample of values stored:-
EMAIL David@Gmail.com, David@Yahoo.com Steve@Gmail.com Steve12@sify.com Rakesh@sify.com
Can you help me to extract Email address and store it delimited by semicolon only to other variable?