Currently Being ModeratedOct 28, 2012 12:32 PM (in response to hotwheels 22)
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
Currently Being ModeratedOct 28, 2012 1:06 PM (in response to Wayne Contello)
i got a great suggestion to Find and Replace all Tabs with Paragraph Returns in Pages.
works good so far.
Currently Being ModeratedOct 28, 2012 1:12 PM (in response to Wayne Contello)
i am realizing it might be nice to format this in numbers as well.
are there specific options for how numbers will format a TAB DELIMITED file?
for instance is there a way to get it to do something like showing the PROMPT in the metadata (Aperture) and any ANSWER THAT I MANUALLY FILLED IN (if any) with each /pair/ of data on a separate line?
i am envisioning something like seeing
"Name My Name" (where there was an entry or just
i mean, this would be an improvement on my replace all TABS with RETURNS method since this method puts /everything/ on a new line.
anyway, someone here is helping me out with this question in Excel but this obviously does not work in numbers and i am not even sure if what they are doing is what i need...
does this question/need make sense to you?
OTHER THREAD LOCATION:
you are saying this is a "comma delimited tab" text file or something?
I said "columns separated by tabs." That means, each element in a line of text is separated by a tab. If you import the file to Excel or filemaker, you can specify that elements are separated by tab characters; then spreadsheet applications will be able to extract the fields that you need. If you do not have Excel, you might try the free open office.
For example, in Excel I see this, after importing Aperture's textfile: sorry, I only have a German version.
You can see, that I specify the data are separated by tabstops, and Excel sorts the fiels accordingly. In Excel I will be able to extract each field "Version name", "Title" separately and to print pdf-files with only the fields I am interested in.
You will need such an intermediate program to bridge the gap between Aperture's output and Acrobat's input.
If you know how to use the Terminal commandline tools, you can extract each field from the text file by using the "cut" filter. It will let you extract any column from the file, but all this will be a lot of work.
Currently Being ModeratedOct 28, 2012 7:02 PM (in response to hotwheels 22)
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.