How To Segregate Duplicate Data And Entire Data In Comma Delimited Text File I Want To Save Data In Two Different Tables And Over Ride Duplicates

Question

1.00/5 (1 vote)

See more:

how to segregate duplicate data and entire data in comma delimited text file i want to save data in two different tables and over ride duplicates
my text file is like below

mobilenumber,   name

919908999775,   sasa
919032540535,   say 
919908999775,   sateee
919908999967,   saj

now i need two tables like below

table1
------------
mobilenumber,   name
919908999775,   sateee
919032540535,   say
919908999967,   saj

table2
-------
919908999775,   sateee

pleasehelp me thanks advance......

Posted 27-Aug-14 4:40am

sateesh kumar nemalikanti

Updated 27-Aug-14 4:57am

Nelek

v2

Add a Solution

Comments

Nelek 27-Aug-14 10:59am

In the first table the same mobile number is used twice, but with different names.
How do you know which one is the correct one? The last that appears? (That's why you are dismissing the name os "sasa"?)

sateesh kumar nemalikanti 12-Sep-14 9:59am

hi nelek i just need to update if duplicates are there. any way thanks ihave solved it

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 · 2014-08-27T05:05:00

Don't try to mix two tables in the same file: use two different files and the task becomes pretty easy.
If you mix them, then you have to find a "clean" way to separate them, and that gets cumbersome.

So have two files "mytext.1.csv" and "mytext.2.csv" and read them both later.
To separate the data, sort it by the phone number - so duplicated values are next to each other - then open two output streams.
Loop through all lines, and if this is the first occurrence, write it to one stream, otherwise write it to the other.