-
January 21st, 2011, 04:37 PM
#1
Suppressing portion of comma delimited string
I have a comma delimited field that has to stay in that format, but I have to suppress everything up to the first comma. And, it will be varying text lengths, so a character count won't work.
Examples:
----------
starting value: horse, cow, dog, pig, cat
needs to display as: cow, dog, pig, cat
----------
----------
starting value: lavender, yellow, aqua, indigo
needs to display as: yellow, aqua, indigo
----------
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-
January 21st, 2011, 05:33 PM
#2
Re: Suppressing portion of comma delimited string
Try with the next formula
Replace {table.field} with your real table & field names
Code:
Mid({table.field},InStr ({table.field},"," ) + 1)
JG
-
January 21st, 2011, 05:43 PM
#3
Re: Suppressing portion of comma delimited string
YOU'RE AWESOME!!!!!! You have NO idea what I've been going through!!! I've been trying to do this for HOURS!!!!!!! DEFINITELY saving that sub-report!!!!!!! THANK YOU!!!!!!!!!!!!!!!!!!!!!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|