Cannot understand how to translate Trim()

[Ronald]

Hi Guys,

We are getting below exception "Cannot understand how to
translate x.FirmName.Trim()" when we try to filter documents on
FirmName by using a dynamic lambda expression which is used in our
linq query to filter.

Expression<Func<CommunityProject, bool>> func = x =>
x.FirmName.Trim().In(anyArchFirm);

here "anyArchFirm" is list of firm names.

Our goal is to match "xyz" with "xyz ", So is there any work around,
please suggest.

Thanks!
a n sarma

[Oren Eini (Ayende Rahien)]

You can't do that in the query, you can trim the value during the indexing:

from x in docs.CommunityProjects

select new { FormName = x.FirmName.Trim() }

[Chris Marisic]

You shouldn't be doing that.

You either want to trim your data coming in that you never save the trailing/leading whitepsace.

Past that, if you need to deal with this data in the database you want to use an approiprate lucene analyzer that will will handle this for you. Honestly I think any of the built in analzyers should allow you to search for "xyz" and find "xyz " except for the NotAnalyzed which is meant to store tokens EXACTLY as they are, this is mainly only useful for primary keys / guids.

[Nageswara Sarma Aravelli]

Thanks Oren