How can I leave all common word from a string?

Question

0.00/5 (No votes)

See more:

Suppose I have a string like that

string str ="a.LastUpdate,a.AgreementID,a.AgreementID,b.CustomerID,a.AgreementID"

the output will be like: str="a.LastUpdate,a.AgreementID,b.CustomerID"

I mean common word will come only one time! Here a.AgreementID has come 3 times.

Posted 26-Feb-14 23:47pm

sachi Dash

Updated 27-Feb-14 0:13am

v3

Add a Solution

6 solutions

Solution 2

Hi,

Take the column names alone(remove the word "SELECT")

Try to tokenize your string into an array of tokens with comma as separaters.

You will get

"a.LastUpdate"
"a.AgreementID"
.
.
.
.

Then you can use old school for loop method to eliminate duplicates by keeping the first one.

Then concatenate the elements into a string with comma in between..

Hope this helps you.

Regards,
C.Kumaresan
http://learnprogrammingeasily.blogspot.in/[^]

Posted 27-Feb-14 0:02am

ckumaresanmba

Comments

OriginalGriff 27-Feb-14 6:05am

Edit your answer and remove the link: it will be counted as spam, and your account could be removed as a result.

Solution 6

try this

var result = strname.Split(new[]{','}, StringSplitOptions.RemoveEmptyEntries).Distinct();

Posted 28-Feb-14 0:32am

agent_kruger

Solution 3

You might:

Remove the 'irregular' part of the string (namely "SELECT ").
Split the string into a string array using the comma as separator.
Add all the array items to a dictionary.
Build again the string concatenating "SELECT " and all the dictionary keys.

(step 3 removes duplicate entries)

Posted 27-Feb-14 0:07am

CPallini

Solution 4

Of course, you can use LINQ to implement steps 2 and 3 of CPallini's solution:

C#

string str ="a.LastUpdate,a.AgreementID,a.AgreementID,b.CustomerID,a.AgreementID";
string noDuplicates = string.Concat(str.Split(',').Distinct());

Posted 27-Feb-14 7:52am

Matt T Heffron

Solution 5

HI,

Try this,

C#

var str = ("a.LastUpdate,a.AgreementID,a.AgreementID,b.CustomerID,a.AgreementID").Split(',');
var res = str.Distinct();

Posted 27-Feb-14 16:25pm

cpquest

Updated 27-Feb-14 16:26pm

v2

Comments

agent_kruger 28-Feb-14 6:31am

sir, this can be done in one line.

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)

OriginalGriff · Accepted Answer · 2014-02-26T23:56:00

More to the point, why are you creating it in the first place?
It's quite hard to do - if your string always starts with SELECT and has nothing after the last comma, then it's not too bad: just strip off the SELECT, split the remainder on the comma, and throw away the duplicates. Then just put it all back together.

C#

string str = "SELECT a.LastUpdate,a.AgreementID,a.AgreementID,b.CustomerID,a.AgreementID,";
string justTheList = str.Substring(7);
string[] elements = justTheList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
str = "SELECT " + string.Join(",", elements.Distinct());

But...it'd be a lot tidier to do it when you generate the string in the first place...