Results 1 to 2 of 2

Thread: substring

  1. #1
    Join Date
    Oct 2005

    Unanswered: substring

    I am using Crystal reports 8.5 and I have a report that I need only courses that do not has a "L" or "C" in the fourth position of the field to appear on my report. How do I substring a data field.For example:
    ACCL 101 shold not appear on the report
    HOUC 205 should not appear on the report
    Last edited by kayjay57; 10-19-05 at 14:00.

  2. #2
    Join Date
    Nov 2003
    Supress the line based on:

    mid(FIELDNAME,4,1) in ('L','C')

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts