Discussion board where members can get started with QlikView.
I have data in the following format
The length of first and last names, and test are not fixed. I want to strip anything after .com. The length of the string after .com is also not fixed.
try this in your script:
SubField(email_field, '.com',1) & '.com' as email_field
Try to look for email validation:
May be like this?
You can replace the string with the field name.