OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

TO FIND DOMAIN VALUE FROM EMAIL ID USING 3.0.

Field Name 'K1' contain the value like 'username@companyname.co.in' means,

we can find domain alone using this formulae

"=MID(MID(k1,FIND("@",k1,1)+1,LEN(k1)),1,FIND(".",MID(k1,FIND("@",k1,1)+1,LEN(k1)),1)- 1))".

result will be 'companyname'.



If 'K1' field contains 'no value' means, it will thro error. To avoid error/exception, add IF condition with formulae like,

' =IF(LEN(K1)>0,MID(MID(K1,FIND("@",K1,1)+1,LEN(K1)),1,FIND(".",MID(K1,FIND("@",K1,1)+1,LEN(K1)),1)- 1),"") '.

Views: 22

Comment

You need to be a member of OrangeScape Developer Community to add comments!

Join OrangeScape Developer Community

© 2017   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service