• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Newbie ?: Truncate Text Field

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
pmickelson
Asked:
pmickelson
  • 2
  • 2
1 Solution
 
AngelRiderCommented:
Create yourself a formula along the lines of the following:

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

That should do you.
0
 
frodomanCommented:
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
 
AngelRiderCommented:
Heh heh, 'scuse my typo..
0
 
pmickelsonAuthor Commented:
THANK YOU, THANK YOU, THANK YOU!
0
 
frodomanCommented:
Glad I could help.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now