Hi,

I have a field that contains mail client but this field contains other data but I just need the mail
a few examples:
"asdasd@ono.com" asdasd@ono.com
asdasd calle plantacalle@asdasd.es
"asdasd_ Dist.asdasd" alicia@asdasd.es
Mike asdasd
"asdasd@asdasd.com"

Thanks you

This message has been edited. Last edited by: Kerry,

Do a Search on GETTOK.

I can get the domain of the mail but the mai??
For example, i have in the field: "asdasd@ono.com" asdasd@ono.com
If I use GETTOK y I have two @ and i can't
Do yo understand??

I would suggest several steps.

1. Remove all " chars with STRREP.
2. Use GETTOK with a delimiter of @, and a token number of -1.
3. Use GETTOK with a delimiter of @, and a token number of -2.
4. Use GETTOK with a delimiter of space and a token number of -1 on the result of step 2
5. Use GETTOK with a delimiter of space and a token number of 1 on the result of step 3
6. Concatenate the results of Step 4 and 5 with the @ char between.

This will cover the examples you have given.

I might be missing the obvious
but based on the examples GETTOK with a delimiter of ' ' and token -1
will return the mail address in every case.

JG, you are right, it will, but the extra code will get an email address from anywhere.