Convert file to .csv format

Discussion in 'Computer Support' started by Dave, Jan 31, 2004.

  1. Dave

    Dave Guest

    Anyone know how to convert a file thatloks like this

    NORTHEAST GP W L T OTL PTS GF GA HOME AWAY L10
    TORONTO 52 28 13 8 3 67 141 122 13-6-2-2 15-7-6-1 5-5-0-0
    OTTAWA 51 28 13 7 3 66 174 108 16-7-4-2 12-6-3-1 6-2-2-0
    BOSTON 52 23 14 11 4 61 126 121 10-8-7-1 13-6-4-3 6-3-1-0
    MONTREAL 52 25 19 6 2 58 127 114 13-9-4-0 12-10-2-2 5-4-1-0
    BUFFALO 53 22 25 5 1 50 127 134 12-9-3-1 10-16-2-0 5-5-0-0

    into a .csv file for spreadsheet insertion?
    Thanks
     
    Dave, Jan 31, 2004
    #1
    1. Advertising

  2. Dave

    °Mike° Guest

    Get a decent text editor, and replace all spaces and, if
    necessary, all carriage returns, with commas.


    On Sat, 31 Jan 2004 23:40:38 GMT, in
    <W1XSb.101490$>
    Dave scrawled:

    >Anyone know how to convert a file thatloks like this
    >
    >NORTHEAST GP W L T OTL PTS GF GA HOME AWAY L10
    >TORONTO 52 28 13 8 3 67 141 122 13-6-2-2 15-7-6-1 5-5-0-0
    >OTTAWA 51 28 13 7 3 66 174 108 16-7-4-2 12-6-3-1 6-2-2-0
    >BOSTON 52 23 14 11 4 61 126 121 10-8-7-1 13-6-4-3 6-3-1-0
    >MONTREAL 52 25 19 6 2 58 127 114 13-9-4-0 12-10-2-2 5-4-1-0
    >BUFFALO 53 22 25 5 1 50 127 134 12-9-3-1 10-16-2-0 5-5-0-0
    >
    >into a .csv file for spreadsheet insertion?
    >Thanks


    --
    Basic computer maintenance
    http://uk.geocities.com/personel44/maintenance.html
     
    °Mike°, Jan 31, 2004
    #2
    1. Advertising

  3. Dave

    Harrison Guest

    1. Using notepad or other text editor, Edit>Find and Replace
    In the "Find box" put one blank space.
    In the "Replace With" box, put a comma.
    Save the file with the csv extension.

    2. Open MS Excel. Choose Data>Import External Data
    Point to the file you wish to convert. Use the wizard to set the
    delimiters, making sure that a space is a delimiter.


    On Sat, 31 Jan 2004 23:40:38 GMT, "Dave" <> wrote:

    >Anyone know how to convert a file thatloks like this
    >
    >NORTHEAST GP W L T OTL PTS GF GA HOME AWAY L10
    >TORONTO 52 28 13 8 3 67 141 122 13-6-2-2 15-7-6-1 5-5-0-0
    >OTTAWA 51 28 13 7 3 66 174 108 16-7-4-2 12-6-3-1 6-2-2-0
    >BOSTON 52 23 14 11 4 61 126 121 10-8-7-1 13-6-4-3 6-3-1-0
    >MONTREAL 52 25 19 6 2 58 127 114 13-9-4-0 12-10-2-2 5-4-1-0
    >BUFFALO 53 22 25 5 1 50 127 134 12-9-3-1 10-16-2-0 5-5-0-0


    NORTHEAST,GP,W,L,T,OTL,PTS,GF,GA,HOME,AWAY,L10,
    TORONTO,52,28,13,8,3,67,141,122,13-6-2-2,15-7-6-1,5-5-0-0,
    OTTAWA,51,28,13,7,3,66,174,108,16-7-4-2,12-6-3-1,6-2-2-0,
    BOSTON,52,23,14,11,4,61,126,121,10-8-7-1,13-6-4-3,6-3-1-0,
    MONTREAL,52,25,19,6,2,58,127,114,13-9-4-0,12-10-2-2,5-4-1-0,
    BUFFALO,53,22,25,5,1,50,127,134,12-9-3-1,10-16-2-0,5-5-0-0,

    >into a .csv file for spreadsheet insertion?
    >Thanks
     
    Harrison, Jan 31, 2004
    #3
  4. Dave

    EGA Guest

    Copy/paste into Excel, highlight the comumn and do data, text to coulmn,
    delimited and use a space

    File Save-As into the CSV...


    "Dave" <> wrote in message
    news:W1XSb.101490$...
    > Anyone know how to convert a file thatloks like this
    >
    > NORTHEAST GP W L T OTL PTS GF GA HOME AWAY L10
    > TORONTO 52 28 13 8 3 67 141 122 13-6-2-2 15-7-6-1 5-5-0-0
    > OTTAWA 51 28 13 7 3 66 174 108 16-7-4-2 12-6-3-1 6-2-2-0
    > BOSTON 52 23 14 11 4 61 126 121 10-8-7-1 13-6-4-3 6-3-1-0
    > MONTREAL 52 25 19 6 2 58 127 114 13-9-4-0 12-10-2-2 5-4-1-0
    > BUFFALO 53 22 25 5 1 50 127 134 12-9-3-1 10-16-2-0 5-5-0-0
    >
    > into a .csv file for spreadsheet insertion?
    > Thanks
     
    EGA, Feb 1, 2004
    #4
  5. Dave

    Dave Guest

    '1.' it is. Thanks

    <Harrison> wrote in message
    news:...
    > 1. Using notepad or other text editor, Edit>Find and Replace
    > In the "Find box" put one blank space.
    > In the "Replace With" box, put a comma.
    > Save the file with the csv extension.
    >
    > 2. Open MS Excel. Choose Data>Import External Data
    > Point to the file you wish to convert. Use the wizard to set the
    > delimiters, making sure that a space is a delimiter.
    >
    >
    > On Sat, 31 Jan 2004 23:40:38 GMT, "Dave" <> wrote:
    >
    > >Anyone know how to convert a file thatloks like this
    > >
    > >NORTHEAST GP W L T OTL PTS GF GA HOME AWAY L10
    > >TORONTO 52 28 13 8 3 67 141 122 13-6-2-2 15-7-6-1 5-5-0-0
    > >OTTAWA 51 28 13 7 3 66 174 108 16-7-4-2 12-6-3-1 6-2-2-0
    > >BOSTON 52 23 14 11 4 61 126 121 10-8-7-1 13-6-4-3 6-3-1-0
    > >MONTREAL 52 25 19 6 2 58 127 114 13-9-4-0 12-10-2-2 5-4-1-0
    > >BUFFALO 53 22 25 5 1 50 127 134 12-9-3-1 10-16-2-0 5-5-0-0

    >
    > NORTHEAST,GP,W,L,T,OTL,PTS,GF,GA,HOME,AWAY,L10,
    > TORONTO,52,28,13,8,3,67,141,122,13-6-2-2,15-7-6-1,5-5-0-0,
    > OTTAWA,51,28,13,7,3,66,174,108,16-7-4-2,12-6-3-1,6-2-2-0,
    > BOSTON,52,23,14,11,4,61,126,121,10-8-7-1,13-6-4-3,6-3-1-0,
    > MONTREAL,52,25,19,6,2,58,127,114,13-9-4-0,12-10-2-2,5-4-1-0,
    > BUFFALO,53,22,25,5,1,50,127,134,12-9-3-1,10-16-2-0,5-5-0-0,
    >
    > >into a .csv file for spreadsheet insertion?
    > >Thanks

    >
     
    Dave, Feb 1, 2004
    #5
  6. Dave

    Harrison Guest

    Glad to help.

    On Sun, 01 Feb 2004 16:46:03 GMT, "Dave" <> wrote:

    >'1.' it is. Thanks
    >
    ><Harrison> wrote in message
    >news:...
    >> 1. Using notepad or other text editor, Edit>Find and Replace
    >> In the "Find box" put one blank space.
    >> In the "Replace With" box, put a comma.
    >> Save the file with the csv extension.
    >>
    >> 2. Open MS Excel. Choose Data>Import External Data
    >> Point to the file you wish to convert. Use the wizard to set the
    >> delimiters, making sure that a space is a delimiter.
    >>
    >>
    >> On Sat, 31 Jan 2004 23:40:38 GMT, "Dave" <> wrote:
    >>
    >> >Anyone know how to convert a file thatloks like this
    >> >
    >> >NORTHEAST GP W L T OTL PTS GF GA HOME AWAY L10
    >> >TORONTO 52 28 13 8 3 67 141 122 13-6-2-2 15-7-6-1 5-5-0-0
    >> >OTTAWA 51 28 13 7 3 66 174 108 16-7-4-2 12-6-3-1 6-2-2-0
    >> >BOSTON 52 23 14 11 4 61 126 121 10-8-7-1 13-6-4-3 6-3-1-0
    >> >MONTREAL 52 25 19 6 2 58 127 114 13-9-4-0 12-10-2-2 5-4-1-0
    >> >BUFFALO 53 22 25 5 1 50 127 134 12-9-3-1 10-16-2-0 5-5-0-0

    >>
    >> NORTHEAST,GP,W,L,T,OTL,PTS,GF,GA,HOME,AWAY,L10,
    >> TORONTO,52,28,13,8,3,67,141,122,13-6-2-2,15-7-6-1,5-5-0-0,
    >> OTTAWA,51,28,13,7,3,66,174,108,16-7-4-2,12-6-3-1,6-2-2-0,
    >> BOSTON,52,23,14,11,4,61,126,121,10-8-7-1,13-6-4-3,6-3-1-0,
    >> MONTREAL,52,25,19,6,2,58,127,114,13-9-4-0,12-10-2-2,5-4-1-0,
    >> BUFFALO,53,22,25,5,1,50,127,134,12-9-3-1,10-16-2-0,5-5-0-0,
    >>
    >> >into a .csv file for spreadsheet insertion?
    >> >Thanks

    >>
     
    Harrison, Feb 1, 2004
    #6
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Helpneeded
    Replies:
    1
    Views:
    36,318
    Juan Pérez
    Dec 3, 2003
  2. Can you convert iCal to CSV

    , Feb 3, 2006, in forum: Computer Support
    Replies:
    2
    Views:
    11,156
    Mitch
    Feb 4, 2006
  3. level_3rd

    Cisco Call Manager 6 CSV Format

    level_3rd, Jun 12, 2008, in forum: General Computer Support
    Replies:
    0
    Views:
    1,504
    level_3rd
    Jun 12, 2008
  4. level_3rd

    Call Manager 6 CDR CSV file

    level_3rd, Jun 12, 2008, in forum: General Computer Support
    Replies:
    0
    Views:
    1,332
    level_3rd
    Jun 12, 2008
  5. laritta
    Replies:
    1
    Views:
    1,229
    laritta
    Aug 16, 2011
Loading...

Share This Page