Skip navigation

quickly printing imported "comma delimited tab" on 8 x11 paper?

275 Views 4 Replies Latest reply: Oct 28, 2012 7:02 PM by Barry RSS
hotwheels 22 Level 1 Level 1 (0 points)
Currently Being Moderated
Oct 28, 2012 12:00 PM

i have a txt file that i am exporting from Aperture which contains metadata in a "comma delimited tab" format. this means it opens in a text editor looking rather scrambled but i can bring it into numbers in individual cells.

 

is there a convenient way to do some kind of "comma delimited tab WRAP" command so that i can quickly print this document out in a text editor with each piece of information on a separate line or even each HEADING on one line and then the entry (if any) on the same line?

 

i want to print this data out but i don't want to have to spend all day messing around with cell width and height (to see all the data) or to spend a lot of time on formatting the final page layout.

 

THANKS

MacBook Pro, OS X Mountain Lion (10.8.1), with 64 bit Win7 Parallels
  • Wayne Contello Level 6 Level 6 (12,580 points)

    Did you try dropping the file (from the Finder) onto the Numbers Application (either in the Applications folder or in the doc)?

     

    You can at least see how Numbers imports the file

  • Barry Level 7 Level 7 (29,095 points)

    Jon,

     

    Numbers will import a csv file (fields in the same record followed by a comma, records by returns) directly, placing each piece of data followed by a comma into the same row, then dropping to a new row after each piece of data followed by a return character.

     

    If your data file is actually a tab delimited file (fields in the same record followed by a tab, last field in a record followed by a return), you can Copy that data (opened into a text editor), then Paste it into a Numbers table. All data in a single record will go into cells in the same line of the table; each record will be on a separate row.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.