how can i use Trim in linq

Question

0.00/5 (No votes)

See more:

Hi,

i am having a Linq expression, i am using orderby for the linq. can you plz tell how can i trim the value of the column.

My Linq expression is:

C#

var distinctvalues = (from row in Employees
                                        select new
                                        {
                                           row.Address
                                        }).Distinct().ToList();

the values i have in the employee is

1) " 1290 rd"
2) "874 sc"

i want to trim the value. can you plz tell me how can i trim the value.

Posted 10-Mar-12 8:59am

inayat basha

Updated 10-Mar-12 9:04am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ekolis · Answer 1 · 2012-03-10T11:11:00

Solution 1

Replace

C#

row.Address

with

C#

row.Address.Trim()

(this is assuming row.Address is a string).

Posted 10-Mar-12 11:11am

ekolis

Comments

inayat basha 10-Mar-12 17:20pm

ya tried it giving me the error

ekolis 10-Mar-12 17:21pm

Really? What error did you get?

inayat basha 10-Mar-12 17:22pm

"cannot assign method group to anonymous type property"

ekolis 10-Mar-12 17:23pm

Did you forget the parentheses after Trim?

inayat basha 10-Mar-12 17:23pm

invalid anonymous type member declarator

ekolis 10-Mar-12 17:25pm

To be honest, I wasn't aware your original post's syntax was correct - I thought you had to give properties of anonymous types names, e.g.
[code="C#"]
new
{
Address = row.Address.Trim()
}
[/code]

btice12 27-Nov-12 16:18pm

Thank you ekolis!!! I had the same question(issue) and this worked perfectly!!!

inayat basha 10-Mar-12 17:24pm

i put that after this the new error is comming

inayat basha 10-Mar-12 17:38pm

no, i have checked with that also

Clifford Nelson · Answer 2 · 2012-03-10T17:45:00

Solution 2

Easy:

C#

var distinctvalues = (from row in Employees
                                        select new
                                        {
                                           row.Address.Trim()
                                        }).Distinct().ToList();

I am assuming that row.Address is a string.

Posted 10-Mar-12 17:45pm

Clifford Nelson

Comments

Clifford Nelson 11-Mar-12 18:56pm

Have not heard anything back. Did it work?