Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

strip unwanted phrases

I have data in the following format

firstname.lastname@test.com

firstname.lastname@test.com.sfdc

firstname.lastname@test.com.pci

firstname.lastname@test.com.lmn

firstname@test.com.xyz

etc

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. 

3 Replies
Highlighted
Not applicable

Rashmi,

try this in your script:

SubField(email_field, '.com',1) & '.com' as email_field

Highlighted
Specialist
Specialist

Hi,

Try to look for email validation:

http://community.qlik.com/message/400046#400046

BR

Ariel

Highlighted
MVP
MVP

May be like this?

Left('firstname.lastname@test.com.lmn',Index('firstname.lastname@test.com.lmn','.com')+3)

You can replace the string with the field name.