Count length of first word using LINQ? C#

Question

1.50/5 (2 votes)

See more:

hi..
I'm reading .csv excel file and i want to count first word length if first word length exactly contains 2 letters then show result .

What I have tried:

C#

private void button5_Click(object sender, EventArgs e)
 {
            result.Clear();
            OpenAndParseFile("DOW30.csv");
            string text = textBox1.Text;
 var r = from DowStock item in result where item.coName ? select item;
            label1.Text = s.ToList().ToString();
            dataGridView1.DataSource = r.ToList();
            dataGridView1.Columns[0].Width = 160;
            dataGridView1.Columns[1].Width = 155;
            dataGridView1.Columns[2].Width = 155;
            dataGridView1.Columns[3].Width = 155;
            dataGridView1.Columns[4].Width = 155;
            dataGridView1.Columns[5].Width = 155; 
           
        }

How can i do this.Show all Dow companies whose stock symbol is exactly 2 characters (such as BA, KO, GE, etc.).Here is table(column) .LINK which i want to count first word letter if two then show result

Posted 9-Dec-16 0:39am

Hameed Khan

Updated 9-Dec-16 1:39am

Add a Solution

2 solutions

Solution 2

C#

var r = from DowStock item in result 
        where item.coName.Value.ToString().Length == 2 
        select item;

Posted 9-Dec-16 1:39am

Jawad Ahmed Tanoli

Updated 13-Dec-16 2:07am

v2

Comments

Hameed Khan 9-Dec-16 7:46am

sorry it will calculate the whole length of string.I just need to check the first word length if first word before space contain two letters then show related data against this column

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)

#realJSOP · Accepted Answer · 2016-12-09T01:30:00

Solution 1

Well, your example code sucks in terms of giving us what we need to be more precise in our answers, but I think this might do it...

C#

var r = result.Where(x=>x.coName.Length == 2);

EDIT =====================

C#

var r = result.Where(x=>x.Split(' ')[0].Length == 2);

Posted 9-Dec-16 1:30am

#realJSOP

Updated 13-Dec-16 2:04am

v4

Comments

Hameed Khan 9-Dec-16 7:44am

i think this one query calculate the whole length not first word length?

Hameed Khan 9-Dec-16 7:46am

sorry it will calculate the whole length of string.I just need to check the first word length if first word before space contain two letters then show related data against this column

#realJSOP 9-Dec-16 7:59am

Seriously man, you gotta at least put some effort into learning about the .net framework.

I edited my response.