Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the script I have the following:
acc_email,
subfield(acc_email,'.',2) as Domain,
subfield(acc_email,'@',2) as Full_Domain,
This works great as long as the email doesn't have another '.' before the @ such as Jane.Smith@gmail.com
How can I get this to work regardless if there is an additional '.' before the @ or not?
Thanks!
Jen
Hi,
You can use subfield with negative value :
subfield(acc_email,'.',-1) as Domain,
Hi,
You can use subfield with negative value :
subfield(acc_email,'.',-1) as Domain,
Thank you!