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


        • 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)


          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.