Parker Software Ltd Homepage
Forum Home Forum Home > ThinkAutomation Business Process Automation > Samples
  New Posts New Posts RSS Feed - How to extract Domain from email
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How to extract Domain from email

 Post Reply Post Reply
Author
Message
JayPatel View Drop Down
New User
New User
Avatar

Joined: 24 May 2012
Location: New York,NY
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote JayPatel Quote  Post ReplyReply Direct Link To This Post Topic: How to extract Domain from email
    Posted: 28 May 2012 at 12:04am
Hi I am trying to extract the domain name from the "from" email address. I do not see a way to do this. eg.  JDoe@microsoft.com is the email address that the email came from, i want to extract the company name between the @ symbol and the .com which should be Microsoft.
 
any help would be appreciated.
 
thanks.
 
Back to Top
Stephen View Drop Down
Admin Group
Admin Group
Avatar

Joined: 21 Oct 2005
Location: Stoke on Trent
Points: 1454
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stephen Quote  Post ReplyReply Direct Link To This Post Posted: 31 May 2012 at 6:05pm
Hi,

Create a field to extract the email address. Then set the extract script for the field to:

Sub Main
Dim A As Integer
A=Instr(1,Email2DBExtract,"@")
If A>0 Then Email2DBExtract = Mid(Email2DBExtract,A+1)
End Sub

Steve
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.05
Copyright ©2001-2016 Web Wiz Ltd.

This page was generated in 0.059 seconds.