Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!eweka.nl!lightspeed.eweka.nl!194.134.4.91.MISMATCH!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <davea@davea.name>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.101
X-Spam-Level: *
X-Spam-Evidence: '*H*': 0.80; '*S*': 0.00; 'iterate': 0.09; 'name...': 0.16; 'wrote:': 0.17; 'subject:request': 0.17; 'define': 0.20; 'stick': 0.22; 'header:In-Reply-To:1': 0.25; 'header:User- Agent:1': 0.26; 'leave': 0.26; 'am,': 0.27; "i'm": 0.29; 'maybe': 0.29; 'club': 0.33; 'ones,': 0.33; 'shorter': 0.33; 'to:addr :python-list': 0.33; 'list': 0.35; 'should': 0.36; 'why': 0.37; 'subject:: ': 0.38; 'to:addr:python.org': 0.39; 'received:192': 0.39; 'list,': 0.39; 'skip:" 10': 0.40; 'received:192.168': 0.40; 'first': 0.61; 'choose': 0.65; 'received:74.208': 0.71; "'e'": 0.84
Date: Mon, 04 Feb 2013 10:30:51 -0500
From: Dave Angel <davea@davea.name>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130106 Thunderbird/17.0.2
MIME-Version: 1.0
To: python-list@python.org
Subject: Re: Improve reduce functions of SQLite3 request
References: <kelbl0$1jv$1@nerdhammel.gnuher.de> <mailman.1317.1359915110.2939.python-list@python.org> <keogmb$dml$1@nerdhammel.gnuher.de>
In-Reply-To: <keogmb$dml$1@nerdhammel.gnuher.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Provags-ID: V02:K0:XV3dJR4SiZxQ7YESqzezZfzJngpS+M2b/q4veZgwnS+ uMU5+PEe2a2PJl6Kv9RH7KGz628WyhBaXPlEb/CCfkCORblg7I V7SvZM2MDMq8yMYJebCIaDcgG+sHIiEDzAsGA6A7OEiUASjS1c SpB+yUR4fbeOSUNdEmpKvDHNPK4Ps86v2gXGLv2qFDzIQr3lXx VeJ50UtirsYBd8t6hqPqPP3As/Uiaf++rzM40pkr/4CP0nxXmg zY0XTpfRj8zbcCjrt6EH3/HxhaDt9j4SJfp/2o0Py/K2UGJHdS q7gJ/you0Cw5wiZRUwWev8eypM5A66F8XxweCfFLXgXSkhTPw= =
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
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.1324.1359992178.2939.python-list@python.org>
Lines: 27
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1359992178 news.xs4all.nl 6947 [2001:888:2000:d::a6]:37459
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:38127

On 02/04/2013 09:30 AM, Steffen Mutter wrote:
<snip>
> 359|TV Calmbach
> 21101|SG Heidel/Helm
> 21236|JSG Neuth/Büch
> 23108|TG Eggenstein
> 23108|TGEggenstein 2 <-
> 23109|TV Ettlingenw
> 23109|TV Ettlingenw 2 <-
> 23112|TSV Jöhlingen
> 23112|TSV Jöhlingen 2 <-
> 23112|TSV Jöhlingen 3 <-
>
> Still not like what I'm looking for.
> Maybe I should iterate through the list, pick out the nr and look for
> the club stick it to a new list and leave out those ones, with the longe
> r club name...
>

Perhaps you should define how you choose to match a shorter & longer 
club name as "equivalent".  For example, why isn't  'E' the shorter name 
to for Ettlingneow and Eggenstein ?

Are you maybe just throwing everything away after the first blank?  Or what?

-- 
DaveA