×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Email Address Field

Email Address Field

Email Address Field

(OP)
All of our Exempts have an email address entered in EV3, some may be company and some may be personal.  Is there a way of puliing a report that shows only the last part of the email address?

I am trying to create a report for personal email addresses, but the email address is not a fixed number of characters.

Any help would be appreciated.

Melanie

RE: Email Address Field

Lets say you want the part starting with the "@" sign.  You could use a SUBSTR in Oracel to pull just a bit of the field like this: SUBSTR(EMAIL_ADDRESS,5,10) This would bring back the part starting at pos 5 and returning up to 10 characters.  

The problem with this is the starting point will very and the length will very.  

Lets address the starting point.  If I use the INSTR function I can find where the "@" is in the address.  INSTR(EMAIL_ADDRESS,'@') will find the first occurance of a "@".  

So if we combine the 2 we get this
SUBSTR(EMAIL_ADDRESS,INSTR(EMAIL_ADDRESS,'@'),10)

Now how do we deal with the length?  We could calculate the length or just plug it with a big number and go with that.  To calulate we could do
(LENGTH(EMAIL_ADDRESS) - INSTR(EMAIL_ADDRESS,'@'))
This is messy looking.  What if we just pluged in something large like 99

SUBSTR(EMAIL_ADDRESS,INSTR(EMAIL_ADDRESS,'@'),99)

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Email Address Field

(OP)
I am using SQL Server, What would work?  

RE: Email Address Field

SUBSTRING(EMAIL_ADDRESS,CHARINDEX('@',EMAIL_ADDRESS),99)

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Email Address Field

(OP)
Thank you so much!  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close