How to remove unwanted delimeters from search result webpart
Feel irritating of the unwanted delimeters appear in your search result of Search Core Results web part?
The special character picks up by the SQL Server Full Text Search which SharePoint search crawler is using. You can try to use Business Data Catalog to expose your data source to SharePoint Search. In this case your data source can be exposed as a web service so you can write some code to hide the delimiter from BDC (and SP Search for this purpose).
BDC is no longer a tedious development job where now we provide tool for you to define the entity definition. Its part of SharePoint 2007 SDK 1.2:https://www.microsoft.com/downloads/details.aspx?familyid=6D94E307-67D9-41AC-B2D6-0074D6286FA9&displaylang=en