Using the DataImportHandler to get filepath from MySQL DataBase BackSlash Character Problem

[Paden <ru...@gmail.com>]

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.

RE: Using the DataImportHandler to get filepath from MySQL DataBase BackSlash Character Problem

["Keswani, Nitin - BLS CTR" <Ke...@bls.gov>]

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.pr@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.