How to remove the duplicates value.

Question

1.00/5 (1 vote)

See more:

Hey in the address column there are duplicates value
e.g Alak Jyot chs flat no 1101 Alak Jyot chs flat no 1101
--Need output as Alak Jyot chs flat no 1101.
-- There are 1000 Plus records like this in address column
Can you please help ?

What I have tried:

--Don't know about this
can you help
thanks in advance

Posted 15-May-18 5:04am

Member 13138564

Updated 15-May-18 5:45am

Add a Solution

Comments

Richard MacCutchan 15-May-18 11:10am

How did the information get there in the first place?

Member 13138564 15-May-18 11:16am

I am getting this file from from client where address has duplicates value.

Richard MacCutchan 15-May-18 11:28am

Then you need to go back to the client and explain that they have a problem in their data.

Member 13138564 15-May-18 12:15pm

Yes you are correct Richard but there should be a solution for this problem.
After solving this i can raise this issue to them.

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)

OriginalGriff · Answer 1 · 2018-05-15T05:46:00

Do it in your presentation language:
Read all rows - check each row, and see if it's a duplicate:

C#

private bool IsDoubled(string s)
    {
    int half = s.Length / 2;
    if (s.Length % 2 != 0)
        {
        half++;
        }
    for (int i = 0, j = half; j < s.Length; i++, j++)
        {
        if (s[i] != s[j]) return false;
        }
    return true;
    }

If it is, use Substring to halve it, and UPDATE the DB Row.