Partial Search

Partial Search

Post by chri » Thu, 06 Feb 2003 05:00:14



Say I have a field that has HGS12065.jpg in it.  How can I search for this
by typing in only 2065?  Thanks.

Chris

 
 
 

Partial Search

Post by Christoph Bouthillie » Thu, 06 Feb 2003 05:20:32


*"2065"

--

Met vriendelijke groet / Mit freundlichen Gr?en / With kind regards
Christoph Bouthillier
post (at) no-no-spam tekstotaal dot com
Please remove "no-no-spam" when e-mailing me directly - Thanks
------


Quote:> Say I have a field that has HGS12065.jpg in it.  How can I search for this
> by typing in only 2065?  Thanks.

> Chris


 
 
 

Partial Search

Post by drew » Thu, 06 Feb 2003 05:41:16




Quote:> Say I have a field that has HGS12065.jpg in it.  How can I search for this
> by typing in only 2065?  Thanks.

> Chris

Or make it a text field.

(another) Chris

 
 
 

Partial Search

Post by chri » Thu, 06 Feb 2003 06:30:34


This is in a text field.



at

> > Say I have a field that has HGS12065.jpg in it.  How can I search for
this
> > by typing in only 2065?  Thanks.

> > Chris

> Or make it a text field.

> (another) Chris

 
 
 

Partial Search

Post by zero1.. » Thu, 06 Feb 2003 11:19:26



> Say I have a field that has HGS12065.jpg in it.  How can I search for this
> by typing in only 2065?  Thanks.

> Chris


 
 
 

Partial Search

Post by drew » Fri, 07 Feb 2003 09:02:44




> This is in a text field.




> at

>>> Say I have a field that has HGS12065.jpg in it.  How can I search for
> this
>>> by typing in only 2065?  Thanks.

>>> Chris

>> Or make it a text field.

>> (another) Chris

Hmm. How about a calc text field which inserts a word space between the text
and numeric components (the .jpg part shouldn't matter). Easy enough to do
expecially if the word length is constant. (In this case Left(TextField,3) &
" " & Right(TextField,9) would return HGS 10265.jpg. You could then search
this field for either "HGS" or "12065". For more complex text deconstruction
consult the experts here.

Chris

 
 
 

1. Partial search using FTS???

Hi,

Is it possible to do perform partial search with FTS? For example, when user
enters "Quark", it should match with "QuarkXpress" or "Refurb" would match
with "Refurbished"... I'm not sure if this is possible or not? If so, which
predicate should I use? A small query example would be greatly appreciated.

Thanks!

HH

2. New Versions of ODBC-Driver for Access

3. TTable partial search

4. Source code documenter tool for Oracle Forms

5. Partial Search ????

6. FPM 2.6 --> FMP3.0 converter

7. Real Partial Search with Borland's Classes

8. Where to store sql strings

9. Implement Partial Search

10. Partial Search.

11. incremental & partial search

12. Partial Searches for paradox tables - Kelian Heyer

13. Optimizing partial searches.