Results 1 to 3 of 3
  1. #1
    mattcoll@TEMPLE.EDU
    Guest

    creating spreadsheets from text output



    Can anyone recommend a simple solution for converting output
    files (when running "Codes: Output: All codes with
    Quotations")to spread sheets without using a complicated
    macro. Basically, the format I am looking for is:

    Column 1 Colunm 2 Column 3
    Code name PD# and name Text

    Thanks!

    Matt Coll
    University of Pennsylvania
    Center For Bioethics
    3401 Market St. Suite 332
    Philadelphia PA
    215-573-4519



  2. #2
    MicheleR
    Guest

    creating spreadsheets from text output



    If the total document isn't too large the easiest way I can think of is to
    drop it into MSWord (I've done it with docs up to 250 pages but depending on
    the version of Word and the amount of memory on your computer too large a
    document will choke Word). Make the page size huge and landscape and drop
    the font size down to about 4 so it's really easy to see where tabs and line
    breaks are. Then do a few search/replaces (I think it only took me five) to
    remove line breaks and then insert tabs where you want the columns divided.
    Then you can either copy/paste it into Excel, or you can save it as plain
    text, rename it with a .csv extension, and open it in Excel.

    Michele

    ----- Original Message -----
    From: <mattcoll@TEMPLE.EDU>
    To: <ATLAS-TI@LISTSERV.DFN.DE>
    Sent: Tuesday, December 21, 2004 11:21 AM
    Subject: creating spreadsheets from text output


    > Can anyone recommend a simple solution for converting output
    > files (when running "Codes: Output: All codes with
    > Quotations")to spread sheets without using a complicated
    > macro. Basically, the format I am looking for is:
    >
    > Column 1 Colunm 2 Column 3
    > Code name PD# and name Text
    >
    > Thanks!
    >
    > Matt Coll
    > University of Pennsylvania
    > Center For Bioethics
    > 3401 Market St. Suite 332
    > Philadelphia PA
    > 215-573-4519


    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.813 / Virus Database: 553 - Release Date: 12/17/2004



  3. #3
    MicheleR
    Guest

    creating spreadsheets from text output



    Sorry, the .csv option won't work, that's for comma-separated files. Do the
    copy-paste thing, or open Excel and then Data > Import External Data and
    tell it to use tabs as the separator.

    Michele

    ----- Original Message -----
    From: "MicheleR" <mrothen2@TWCNY.RR.COM>
    To: <ATLAS-TI@LISTSERV.DFN.DE>
    Sent: Tuesday, December 21, 2004 12:15 PM
    Subject: Re: creating spreadsheets from text output


    > If the total document isn't too large the easiest way I can think of is to
    > drop it into MSWord (I've done it with docs up to 250 pages but depending
    on
    > the version of Word and the amount of memory on your computer too large a
    > document will choke Word). Make the page size huge and landscape and drop
    > the font size down to about 4 so it's really easy to see where tabs and
    line
    > breaks are. Then do a few search/replaces (I think it only took me five)
    to
    > remove line breaks and then insert tabs where you want the columns
    divided.
    > Then you can either copy/paste it into Excel, or you can save it as plain
    > text, rename it with a .csv extension, and open it in Excel.
    >
    > Michele
    >
    > ----- Original Message -----
    > From: <mattcoll@TEMPLE.EDU>
    > To: <ATLAS-TI@LISTSERV.DFN.DE>
    > Sent: Tuesday, December 21, 2004 11:21 AM
    > Subject: creating spreadsheets from text output
    >
    >
    > > Can anyone recommend a simple solution for converting output
    > > files (when running "Codes: Output: All codes with
    > > Quotations")to spread sheets without using a complicated
    > > macro. Basically, the format I am looking for is:
    > >
    > > Column 1 Colunm 2 Column 3
    > > Code name PD# and name Text
    > >
    > > Thanks!
    > >
    > > Matt Coll
    > > University of Pennsylvania
    > > Center For Bioethics
    > > 3401 Market St. Suite 332
    > > Philadelphia PA
    > > 215-573-4519
    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.813 / Virus Database: 553 - Release Date: 12/17/2004


    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.813 / Virus Database: 553 - Release Date: 12/17/2004



Similar Threads

  1. creating cross-tab like output
    By glsciarra in forum General
    Replies: 1
    Last Post: 2006-01-04, 05:35 PM
  2. output of uncoded text?
    By Philippe Bourgois in forum Archive 1999-2004
    Replies: 1
    Last Post: 2003-05-15, 10:26 AM
  3. spreadsheets as primary docs
    By Bruce Havelock in forum Archive 1999-2004
    Replies: 1
    Last Post: 2002-05-16, 04:49 PM
  4. text format of output
    By Nick Woolf in forum Archive 1999-2004
    Replies: 2
    Last Post: 2000-12-21, 09:46 AM
  5. text output
    By David Leiser in forum Archive 1999-2004
    Replies: 1
    Last Post: 1999-12-28, 07:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •