how to compare words by appending and also splitting in sentence

Question

0.00/5 (No votes)

See more:

i had a csv file which has words in it. in each column the file has one word and some columns have two words . i have a sentence which i had splitted in to words and i have to compare the words in sentence with the words in csv file and get which words present in sentence and also in csv file . i am able to compare for single word but some rows are having two words in csv file like "let stay" made sure" e.t.c so i have to append two words and compare it and also split the words and compare individually . how to do that . is this approach correct?

Posted 24-May-15 23:23pm

Member 11532585

Updated 24-May-15 23:33pm

v3

Add a Solution

Comments

Abhipal Singh 25-May-15 5:39am

Is there any issue if you could split multiple words into multiple columns?
for ex:
"let stay" in one cell will be changed to "let" and "stay" in two different cells.

1 solution

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)

King Julien · Answer 1 · 2015-05-25T21:30:00

Instead of splitting the sentence in to single words, why don't you use string.Contains method and iterate through each column of your csv file ?

Sample Code:

C#

string my_sentence = "The quick brown fox jumps over the lazy dog";

            List<string> found_string_collection = new List<string>();

            string[] csv_column_text = { "fox", "dog", "jumps over", "quick" };

            foreach (string text in csv_column_text)
            {
                if (my_sentence.Contains(text))
                {
                    found_string_collection.Add(text);
                }
            }

</string></string>