Hi Paden,

I believe you could use a PatternReplaceFilterFactory ( 
http://lucene.apache.org/core/4_0_0/analyzers-common/org/apache/lucene/analysis/pattern/PatternReplaceFilterFactory.html
 )
 configured in your fieldtype that could replace '\\\\' with '\\' at index time.

Thanks.

Regards,

Nitin Keswani

-----Original Message-----
From: Paden [mailto:rumsey...@gmail.com] 
Sent: Tuesday, June 30, 2015 3:59 PM
To: solr-user@lucene.apache.org
Subject: Using the DataImportHandler to get filepath from MySQL DataBase 
BackSlash Character Problem

Hello, 

I'm having a slight "Catch-22" scenario going on with my Solr indexing process. 
I'm using the DataImportHandler to pull a filepath from a database.
The problems is that Windows filepaths have the backslash character inside 
their paths. 

\\some\filepath

So when insert this data into MySQL I have to use a "\\" in order to get it to 
look like it should 

\\\\some\\filepath

And everything looks good when I put it into MySQL it looks like 

\\some\filepath

But when I index into Solr it looks like this

\\\\some\\filepath

Now I was thinking that I should just go back and put in single backslashes 
again since it's printing the exact input that I used to put the string in the 
table in MySQL but then it does this wonderful trick

\\somefilepath

It will recognize the front two but not that middle backslashes. 

I know this may seem like more of a MySQL kind of issue but is there any way 
that I can get solr to recognize this escape character so it would print the 
desired output? 



--
View this message in context: 
http://lucene.472066.n3.nabble.com/Using-the-DataImportHandler-to-get-filepath-from-MySQL-DataBase-BackSlash-Character-Problem-tp4215034.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to