Path: csiph.com!usenet.pasdenom.info!news.albasani.net!news.mixmin.net!feed.xsnews.nl!border-2.ams.xsnews.nl!xlned.com!feeder1.xlned.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <d@davea.name>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.017
X-Spam-Evidence: '*H*': 0.97; '*S*': 0.00; 'algorithm': 0.03; 'cursor': 0.09; 'must,': 0.09; 'other,': 0.09; 'subject:files': 0.09; 'cc:addr:python-list': 0.10; 'mechanism.': 0.16; 'stuff,': 0.16; 'tradition': 0.16; 'wrote:': 0.17; 'comparing': 0.17; 'exceptions': 0.22; 'cc:2**0': 0.23; 'cc:no real name:2**0': 0.24; 'second': 0.24; 'least': 0.25; 'cc:addr:python.org': 0.25; 'header :In-Reply-To:1': 0.25; 'header:User-Agent:1': 0.26; 'skip:" 20': 0.26; 'fixed': 0.28; 'subject:list': 0.28; 'decide': 0.28; 'case,': 0.29; 'probably': 0.29; "i'm": 0.29; 'figure': 0.30; 'code': 0.31; 'file': 0.32; 'problem': 0.33; "can't": 0.34; 'wrong': 0.34; 'text.': 0.35; 'doing': 0.35; 'pm,': 0.35; 'there': 0.35; 'created': 0.36; 'but': 0.36; 'should': 0.36; 'subject:: ': 0.38; 'some': 0.38; 'sure': 0.38; 'delete': 0.38; 'received:192': 0.39; 'received:192.168': 0.40; 'help': 0.40; 'end': 0.40; 'your': 0.60; 'most': 0.61; 'first': 0.61; 'header:Reply-To:1': 0.68; 'programs,': 0.71; 'received:74.208': 0.71; 'reply-to:no real name:2**0': 0.72; 'understand,': 0.84
Date: Mon, 26 Nov 2012 22:23:50 -0500
From: Dave Angel <d@davea.name>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121011 Thunderbird/16.0.1
MIME-Version: 1.0
To: Anatoli Hristov <tolidtm@gmail.com>
Subject: Re: Compare list entry from csv files
References: <CAKhY55M3iOhhMbn=VuwJ7OMz_JUHVxwGy1h_BDpfBY8jQ5aRkA@mail.gmail.com> <50B3E865.9070700@davea.name> <CAKhY55OUNvGFhCjZLS7HNoDydKqHxZrnaN+bWySCsmKSk1vqsw@mail.gmail.com>
In-Reply-To: <CAKhY55OUNvGFhCjZLS7HNoDydKqHxZrnaN+bWySCsmKSk1vqsw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Provags-ID: V02:K0:bDVi3WW+9FrUpY+di/D+KoT4Mr9MRXrvhRS/YKJ8cjM lsbFUUp9e1gB0JTxaeyb5tOKaycarkcV2HgD7NuXpnLs/wuXrg wFSgWggL4bUEKj3sJvzXHSiCuoXG5eqBw5zJ69pG8Z3xS7Kngo ToWWeURIHJO5pc6TVDWRpOrYurUuslnIAVrHAX99FGptwKy/Qt rPZSLm1evupkCmy5GbE0RoiTJiEq00B7oRmJhLpBhTDj47JCpb GPPEDObDHwHAUmSeqYOOatR0YJkc+tYVVpkKlKwdWQ4ZZbJLch sXR1AKIJ435q+wxmoYMxI6IXyuor8cg6b+zcZB6+8opoXvqog= =
Cc: python-list@python.org
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
Reply-To: d@davea.name
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.308.1353986648.29569.python-list@python.org>
Lines: 26
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1353986648 news.xs4all.nl 6878 [2001:888:2000:d::a6]:59949
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:33962

On 11/26/2012 05:27 PM, Anatoli Hristov wrote:
> I understand, but in my case I have for sure the field "Name" in the
> second file that contains at least the first or the last name on it...
> So probably it should be possible:)
> The Name "Billgatesmicrosoft" contains the word "Gates" so logically I
> might find a solution for it.
> 

(Please don't top-post.  Or if you must, then delete everything after
your post, as I'm doing here.  Otherwise you end up with insanities like
new stuff, quote-4, quote-1, quote-3, quote-2.  In this case, long
tradition on this forum and many like it work well, even if Microsoft
mail programs and some others decide to put the cursor at the wrong end
of the existing text.  In most programs, it's configurable.)

If you can come up with an algorithm for comparing first+last in one
file to name in the other, then the problem can be solved.  But you
can't do it by hand-waving, you have to actually figure out a mechanism.
 Then we can help you code such a thing.  And I can just about guarantee
that if these fields are created independently by human beings, that
there will be exceptions that have to fixed by human beings.


-- 

DaveA