Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: strip unwanted phrases

Rashmi,

try this in your script:

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

Highlighted
Specialist
Specialist

Re: strip unwanted phrases

Hi,

Try to look for email validation:

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

BR

Ariel

Highlighted
MVP
MVP

Re: strip unwanted phrases

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.