Searching Stripped Values

[#1]

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,

[#2]

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.

[#3]

Tim,

Thanks for the response, it is technically what I wanted to accomplish however it really slows down the search. I guess I can load this into the script somehow....

[Anonymous]

Hey Les,

You can create a searchfield in the script. I'd suggest using PurgeChar() to remove the characters you don't want.

Load
Field,
PurgeChar(Field,'-/#') as SearchField;
LOAD * INLINE [
Field
1-1/2ABC
];