Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

subfield used to breakout email address

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

1 Solution

Accepted Solutions
christophebrault
Specialist
Specialist

Hi,

You can use subfield with negative value :

subfield(acc_email,'.',-1) as Domain,

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin

View solution in original post

2 Replies
christophebrault
Specialist
Specialist

Hi,

You can use subfield with negative value :

subfield(acc_email,'.',-1) as Domain,

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Anonymous
Not applicable
Author

Thank you!