spanish chars, date sections, highlight keywords on results...
Msg#: 3119 posted 4:59 pm on Feb 13, 2004 (gmt 0)
We've been looking for a decent search app for our archive. We have a newsletter and we would like to be able to search within date periods(from xx/xx/****x to yy/yy/yyyy), to highlight the matched keywords, among other things like accept spanish characters (á, é, í, ó, ú, ń). Anyone knows an app capable of these?
Thanks in advance!
Msg#: 3119 posted 11:23 pm on Feb 18, 2004 (gmt 0)
Try using a function that data can be passed into along with the search term. Use a regular expression to identify matching character patterns then wrap it in a style highlight. Have the function return the data with the matched patterns highlighted. It shouldn't matter what characters are submitted as the pattern.
Msg#: 3119 posted 1:59 am on Feb 19, 2004 (gmt 0)
Some suggested solutions.
I think your list is store in some database and if you already separated date of the messages in some different colum of the table , then you can use sql query to fetch the records for date range.
Other not so good but may work tip is to tag your email messages with xml, in your email list for example for your date yy/yy/yyyy
you can do the following :
And with your application you can parse with XML parser and use some date function ,most programming have functions to compare dates and they will work.
This is not so good way of doing searches because as the search data grows the search will be slower and other problems also increase which is hard for me to explain here.
Hope this helps.
Msg#: 3119 posted 2:52 am on Feb 19, 2004 (gmt 0)
Nah... it shouldn't get too much slower if you create agent jobs to do date range archiving and indexing. Base it on usual queries and you can keep things cranking for a long time. Yeah... archiving...
you can archive information considered "old" by whatever standard you might set... like 90 days for example. If a date range is outside of 90 days from the current date, then you can include "archived" data in the returned results. Otherwise... you simply ignore it... just a method of limiting information overload ;-)
Msg#: 3119 posted 10:41 am on Feb 19, 2004 (gmt 0)
|accept spanish characters |
If I'm not mistaken, Java chars are 16bit Unicode. This means that a Java String accepts spanish characters (and also chinesse and tibetan, for example ;))
|I think your list is store in some database and if you already separated date of the messages in some different colum of the table, then you can use sql query to fetch the records for date range. |
And if you didn't, you can do it now. You only need a sql selection query, a text parser and a sql table creation query. If you can export your db to MS access, you will be able to separate the date using a VBA function. I have not worked with many database tools, so I don't know them, but I supose that this can also by done with many other tools.
If you have not even a database, you can create it from separated files with many programming tools.
So, the best solution, make a database with clearly separated fields (separate date from text, if you didn't) and a search Java servlet.