Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jenstarr
New Contributor III

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
Valued Contributor

Re: subfield used to breakout email address

Hi,

You can use subfield with negative value :

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

2 Replies
christophebrault
Valued Contributor

Re: subfield used to breakout email address

Hi,

You can use subfield with negative value :

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

jenstarr
New Contributor III

Re: subfield used to breakout email address

Thank you!

Community Browser