2 Replies Latest reply: Nov 19, 2012 1:48 PM by yallow83 RSS

    Straight table - limit selection

      Hi guys,

       

      Thanks for looking!

       

      I have a straight table where I would like to only show those items that have string lenth of more than 5.

       

      For example, now I have

       

      Item ID
      QtySalesCost
      Total1010050
      GEF55025
      ABCABC32010
      123456723015

      I would like to exlude "GEF" from this stragiht table.

       

      How can I do this?

       

      I found a way to exclude it by adding a len(Item ID) column to my load statement and exluding all short items IDs in a list box.

      However this way my current selections box gets "dirty" with selections that I don't want to show to the end User.

       

      Is there a better way to limit raw data provided for straight table output?

       

      Thanks!