I have a dataset with multiple rows of text. Somewhere on each row, there is
an email adress that I want to place in new variable. The complicated thing
is that one row can hold more than one email adress. However, I only want
the first one on the row.
I want a SUBSTR(SOURCE,START,LENGTH) function where START is based on the
rightmost occurence of an illegal email character on the left hand side of
Hmm... Not very easy to understand, I guess. But I have something like:
new file .
/text 1-100(a) .
end data .
And I want a variable that looks like this: