Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extracting Characters after a comma?? 3

Status
Not open for further replies.

strom99

MIS
Nov 28, 2000
126
US
Easy question for someone, how do I extract the characters after a comma in a field??
 
What have you tried? Steven Fowler, Principal
steve.fowler@fowlerconsulting.com
- Development, Training, and Consulting
wpe1.gif
 
I tried the split function using "," as the delimeter, but said formula error, I don't know what else to try.
 
If (InStr({stringfield}, ',') + 1) <= Length({stringfield}) then
{stringfield}[(InStr({stringfield}, ',') + 1) to Length({stringfield})]
Else
'' Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top