Improve company productivity with a Business Account.Sign Up

x
?
Solved

Newbie ?: Truncate Text Field

Posted on 2004-04-21
5
Medium Priority
?
324 Views
Last Modified: 2008-03-17
Thanks Ahead of time:

I am presuming this is an easy one.
I have an e-mail field that I would like to remove the e-mail extension.  
Example:
"abc123@pleasehelp.com" into just "abc123"

Any help appreciated.
0
Comment
Question by:pmickelson
  • 2
  • 2
5 Comments
 
LVL 1

Expert Comment

by:AngelRider
ID: 10882722
Create yourself a formula along the lines of the following:

Left({email-field}, 1, InStr({email-field}, '@') - 1)

That should do you.
0
 
LVL 42

Accepted Solution

by:
frodoman earned 200 total points
ID: 10882855
That actually won't work.  You'll need either this:

Left({email-field}, InStr({email-field}, '@') - 1)

or this:

Mid({email-field}, 1, InStr({email-field}, '@') - 1)


Both give the same results.
0
 
LVL 1

Expert Comment

by:AngelRider
ID: 10883061
Heh heh, 'scuse my typo..
0
 

Author Comment

by:pmickelson
ID: 10883130
THANK YOU, THANK YOU, THANK YOU!
0
 
LVL 42

Expert Comment

by:frodoman
ID: 10887632
Glad I could help.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question