strip unwanted phrases

[#1]

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. 

[#2]

Rashmi,

try this in your script:

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

[ariel_klien]

Hi,

Try to look for email validation:

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

BR

Ariel

[tresesco]

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.