Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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.