Why use a cannon on a gnat?
Your data is already in an Excel spreadsheet, so why not use Excel to do
this?
=ISODD(LEFT(A1,SEARCH(" ",A1)-1))
Will be true if the street number is odd; then you can just filter on that
column to select the "TRUE" rows, and copy them to wherever you need them.
>-----Original Message-----
>From: Jason Pruim [mailto:japr...@raoset.com]
>Sent: Monday, February 02, 2009 1:27 PM
>To: mysql@lists.mysql.com
>Subject: grabbing even addresses?
>
>Hello!
>
>I was wondering if something was possible, I have an excel file right
>now of US mailing addresses, and what I need to do is select all the
>odd numbered addresses on one road, is there an easy way I can do
>that from MySQL? the addresses could contain 3, 4 or 5 numbers per
>addresses such as:
>
>123 Main
>1232 Main
>1233 Main
>1234 Main
>12345 Main
>
>and what I want out of those would be:
>
>1232 Main
>1234 Main
>
>Any ideas? Thanks for looking! :)
>
>
>--
>Jason Pruim
>japr...@raoset.com
>616.399.2355
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
