3 Replies Latest reply: Nov 24, 2010 10:04 PM by Johannes Sunden RSS

    Searching Stripped Values

      Hi Community,

      Does anyone know if it is possible to do searches on listboxes or in a search box for the stripped down version of a result?

      What I mean by this, for example I have product codes 1-1/2ABC, I would like to just search 112ABC to find the result.....

      Thanks,

        • Searching Stripped Values
          Tim Benoit

          Create a listbox with an expression in it instead of the field. Start by creating a new listbox and in the list of fields look for the <expression> entry and click on that. For an expression use something like this: (assuming that your field name is PRODUCT)

          =replace(replace(PRODUCT,'/',''),'-','')

          That expression will remove slash and dash characters. You can make selections on the values and the selections will actually be made on the PRODUCT field.