OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Select ... INTO fn gets 1000 return code from MySQL 5.x
Goto page Previous  1, 2
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
bmcswain
General User
General User


Joined: 23 Feb 2007
Posts: 11

PostPosted: Sat Feb 24, 2007 3:33 pm    Post subject: Reply with quote

Let me say "Thank You" again for all that responded and even those that thought about responding.

The power of this medium is the collection of us out here. We can help each of us to move forward.

I have finished my project. The data is refined and purified and usable by anyone with a spreadsheet.

Thanks!
Bob
_________________
Bob
Back to top
View user's profile Send private message AIM Address
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Sat Feb 24, 2007 5:09 pm    Post subject: Reply with quote

Bob:

Just FYI ( For Your Information ) and for anyone else reading this . . . another method to create a CSV ( Comma Separated Value ) file from the contents of a Base table is:
  1. Open your OpenOffice Base database file
  2. From the Menu: Tools -> SQL...
  3. In the Command to execute box, enter your SQL with one change . . . add a line BEFORE the "FROM clause"

    INTO TEXT "precinct_ 69_2007-02-23"

    so that the 'output' will be placed in the named file with a CSV extension, in the same directory as your ODB file . . . in this case file name . . . precinct_69_2007-02-23.csv
    Code:
    SELECT DISTINCT
          "Name: Last,First,Middle",
          "Res Addr: Full",
          "Res Addr: City,State,Zip"
       INTO TEXT "precinct_69_2007-02-23"
       FROM "Precinct 69"

  4. Press Execute button
  5. Press Close button


I hope this helps . . . and . . . best of success.

Sliderule
Back to top
View user's profile Send private message
bmcswain
General User
General User


Joined: 23 Feb 2007
Posts: 11

PostPosted: Tue Feb 27, 2007 7:30 pm    Post subject: Reply with quote

OK... Just to finish the thread...

My last task was to split the house number from the street name.

Way simple ... compared to the previous step.

Download CSVed and it's done.

Under one of the split techniques, you can split at a certain character. Since house numbers can be 2, 3, 4 or 5+ numbers, CSVed allows you to split it following the " " (blank) after the number.

Simple.

But not if you had not helped me.

Thanks to the online community.
_________________
Bob
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group