Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data in the following format
firstname.lastname@test.com.sfdc
firstname.lastname@test.com.pci
firstname.lastname@test.com.lmn
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.
Rashmi,
try this in your script:
SubField(email_field, '.com',1) & '.com' as email_field
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.