Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Full Text indexing and numbers inside
Fri, Nov 19 2010 7:28 PMPermanent Link

Howard Barlow

I'm having issues where full text index does not do numbers.  How can I make it include numbers in the index.  Say a something like 'concrete filling 3000 yards'.  I'm able to search any item in the text field, but I type in 3000 with a CONTAINS or DOES NOT CONTAIN and I get nothing.
Sat, Nov 20 2010 1:52 AMPermanent Link

Terry Swiers

??Howard,

> I'm having issues where full text index does not do numbers.  How can I
> make it include numbers in the index.  Say a something like 'concrete
> filling 3000 yards'.  I'm able to search any item in the text field, but I
> type in 3000 with a CONTAINS or DOES NOT CONTAIN and I get nothing.

You will need to create an external word generator and use that instead of
the default one.   I have one that I worked up for EDB2 that includes
numbers, and a few additional characters that my customers need.  If you
want it, just let me know and I'll clean it up a bit and push it up to the
contributions newsgroup.

--
---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Now shipping Atrex 13. For more information go to
http://www.atrex.com/news.asp

Atrex Electronic Support Options:
Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------  
Mon, Nov 22 2010 11:55 AMPermanent Link

Howard Barlow

That would be very kind of you, and very much appreciated.

-Howard


"Terry Swiers" wrote:

??Howard,

> I'm having issues where full text index does not do numbers.  How can I
> make it include numbers in the index.  Say a something like 'concrete
> filling 3000 yards'.  I'm able to search any item in the text field, but I
> type in 3000 with a CONTAINS or DOES NOT CONTAIN and I get nothing.

You will need to create an external word generator and use that instead of
the default one.   I have one that I worked up for EDB2 that includes
numbers, and a few additional characters that my customers need.  If you
want it, just let me know and I'll clean it up a bit and push it up to the
contributions newsgroup.

--
---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Now shipping Atrex 13. For more information go to
http://www.atrex.com/news.asp

Atrex Electronic Support Options:
Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------  
Mon, Nov 22 2010 5:35 PMPermanent Link

Terry Swiers

?Howard,

> That would be very kind of you, and very much appreciated.

Happy to help.  I've uploaded it to the ElevateDB extensions newsgroup.

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Atrex Electronic Support Options:
Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------
Image