Subject Re: [IBO] Full Text Search and Numbers
Author Jason Wharton
I want to further suggest that you use a sorted stringlist set to ignore
duplicates so tha when you have numbers with duplicate sequences they won't
be duplicated in your word index.

This way if your number was this: 123123

Your word list would be:

123 <- Is only in here once.
231
312
1234
2341
3123
12345
23123
123123

Hope this helps.

Jason LeRoy Wharton


----- Original Message -----
From: "Jason Wharton" <supportlist@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, August 21, 2009 1:47 PM
Subject: Re: [IBO] Full Text Search and Numbers


> Robert,
>
>> I have already established with Jason that Full Text Search is not
>> capable
>> of search lists of codes ie.
>>
>> BARCODE
>>
>> 09938383908283
>> 88388237898239
>> 38472387823723
>> 73924983478932
>>
>>
>> User then types in "932"
>> the search should return the bottom code.
>>
>> However because of the way Full Text Search works it treats codes
>> differently to actual words.
>
> As I said before, in order to have fast Full Text Searching as it appears
> you want you need to override the event to generate the word list for each
> entry such that it does the following:
>
> (I'm assuming you won't trigger a search with fewer than 3 digits)
>
> Text to search:
>
> 123456
>
> Words generated:
> 123
> 234
> 345
> 456
> 1234
> 2345
> 3456
> 12345
> 23456
> 123456
>
> Once the index has all of the possible combinations of unique words in it
> then when a user types in a search it will find it against a straight
> index
> of your word table.
>
> Does this make sense?
>
> Regards,
> Jason LeRoy Wharton