Home » Server Options » Text & interMedia » Indexing comma delimited Info.- (Oracle 10g, 10.2.0.3)
|Indexing comma delimited Info.- [message #383220]
||Tue, 27 January 2009 16:50
Registered: March 2008
Location: Guatemala, C.A.
Hello, i'm working on a solution based on oracle text to index names of people and companies, but the problem is how to handle a delimiter that is part of the data, this is the sintax:|
[1st last name],[2nd last name], [married last name], [1st first name],[2nd first name]
Ej.:(note: on a missing married last name it omits the string and you get ,,) like :
Using all fields:
In other hand you have in the same table and field, names of companies like:
As you see some times there's a visible white space( ) between words, but in regular cases like:
In the index table(XXX$I) i get a full name token it doesnt take logic tokens like:
Is there a way to configure context to set the , as a break word and get this right(already tried to set the character(,) in the break words with no luck)?
Or do you suggest any strategy on this?
Thanks for your comments
[Updated on: Wed, 28 January 2009 09:44]
Report message to a moderator
Current Time: Wed Jan 27 08:36:33 CST 2021