Discussion Board for collaboration on QlikView Scripting.
In the script I have the following:
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?
Go to Solution.
You can use subfield with negative value :
subfield(acc_email,'.',-1) as Domain,