Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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....
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
];