CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    8

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

  2. #2
    Join Date
    Jul 2005
    Posts
    1,083

    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

  3. #3
    Join Date
    Jan 2011
    Posts
    8

    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
  •  





Click Here to Expand Forum to Full Width

Featured