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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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
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!!!!!!!!!!!!!!!!!!!!!