Suppressing portion of comma delimited string

[TrinXTC]

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

[jggtz]

Try with the next formula
Replace {table.field} with your real table & field names

Mid({table.field},InStr ({table.field},"," ) + 1)

JG

[TrinXTC]

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