WEB exporting sql file question

Discussion in 'OT Technology' started by DnA02, Apr 1, 2009.

  1. DnA02

    DnA02 Hey, how YOU doin?! OT Supporter

    Joined:
    May 27, 2004
    Messages:
    1,914
    Likes Received:
    0
    im exporting emails from my sql database but when i export to csv, excel, etc.

    the format comes out like this:

    [email protected]
    [email protected]
    [email protected]
    etc.
    etc.

    What can i do so that the emails will look like the following below:

    [email protected],[email protected],[email protected]

    What are ways of accomplishing the above? Is there a feature in word/excel etc. that will reformat the emails for me?
     
    Last edited: Apr 1, 2009
  2. Krakerjak

    Krakerjak Active Member

    Joined:
    Jul 7, 2003
    Messages:
    8,288
    Likes Received:
    0
    Location:
    Edmonton eh
    when exporting the file choose to terminate fields as well as lines with ','
    the defaults are ; and AUTO
     
  3. 2ofdem

    2ofdem OT Supporter

    Joined:
    Jun 17, 2003
    Messages:
    114,854
    Likes Received:
    8
    Location:
    aus.vic.mel
    any decent text editor

    do a find replace on the carriage return character replace it with ', '
     
  4. noon

    noon get high and teach me how to listen

    Joined:
    May 4, 2002
    Messages:
    3,384
    Likes Received:
    0
    Location:
    Lawrence, KS
    well what program are you using to export? phpMyAdmin?
     
  5. DnA02

    DnA02 Hey, how YOU doin?! OT Supporter

    Joined:
    May 27, 2004
    Messages:
    1,914
    Likes Received:
    0
    yeah, phpmyadmin
     
  6. noon

    noon get high and teach me how to listen

    Joined:
    May 4, 2002
    Messages:
    3,384
    Likes Received:
    0
    Location:
    Lawrence, KS
    On the export screen, tick "CSV" and try these settings:

    [​IMG]
     
  7. noon

    noon get high and teach me how to listen

    Joined:
    May 4, 2002
    Messages:
    3,384
    Likes Received:
    0
    Location:
    Lawrence, KS
    If that doesn't work, tick "CSV for MS Excel" with these settings:

    [​IMG]
     
  8. 95vr4

    95vr4 OT Supporter

    Joined:
    Oct 6, 2004
    Messages:
    2,513
    Likes Received:
    0
    Location:
    Weddington, NC
    like 2ofdem said.... just use UltraEdit's "Search and Replace" (or a similar program), shouldn't take you more than a few seconds to get it formatted how you want it

    if you want to pm me the list I'll do it for you real quick
     
  9. 95vr4

    95vr4 OT Supporter

    Joined:
    Oct 6, 2004
    Messages:
    2,513
    Likes Received:
    0
    Location:
    Weddington, NC
    also, for anyone that uses phpmyadmin....try sqlyog, it's :bowdown:, couldn't live without it....and the community edition (free version) is basically full featured.

    http://www.webyog.com/en/downloads.php
     
  10. 2ofdem

    2ofdem OT Supporter

    Joined:
    Jun 17, 2003
    Messages:
    114,854
    Likes Received:
    8
    Location:
    aus.vic.mel
    . I use it for all my MySQL admin crap makes everything simple.
     
  11. 95vr4

    95vr4 OT Supporter

    Joined:
    Oct 6, 2004
    Messages:
    2,513
    Likes Received:
    0
    Location:
    Weddington, NC
    phpmyadmin or sqlyog?
     

Share This Page