topic Re: Fuzzy Search... in Application Development and Automation Discussions

Fuzzy Search...

Former Member — Tue, 05 Feb 2008 12:31:12 GMT

Hi,

I would like to know how to incorporate a fuzzy search in a field.

For example... if an user enters TEST* in a selection screen field p_var , I should display all the records which has the p_var starting with TEST..... if the user enters TEST than I should display all the records contains the string TEST

Thanks,

Suresh

Re: Fuzzy Search...

RaymondGiuseppi — Tue, 05 Feb 2008 12:43:29 GMT

Declare the PARAMETER as a SELECT-OPTIONS.

If only one field should be displayed use NO-EXTENSION and NO INTERVALS options.

Then in your program use SELECT (...) WHERE <field> IN <select-option>

(If you use LIKE instruction you will have to map the "*" into "%")

Regards

Re: Fuzzy Search...

Former Member — Tue, 05 Feb 2008 13:03:33 GMT

try this,

if p_var CA '*' .

split p_var at '*' into var1 var2.

concatenate 'var1' '%' into var1.

condense var1.

select <fields> from <DB> where

<field> like var1.

else.

concatenate '%' 'var1' '%' into var1.

condense var1.

select <fields> from <DB> where

<field> like var1.

endif.

"<var1> and <var2> are string type variables