How do I export a specific set of rows from Numbers?

Question

Level 1

12 points

What i am looking to be able to do is

Export a specific set of rows from Numbers

I am working with large files of information

but would like to break the file up into smaller files

for example

I have 1 file with 40,000 rows

I need to be able to export/save this file into 4 smaller files

Rows 1-10,000

Rows 10,001-20,000

Rows 20,001-30,000

Rows 30,001-40,000

MacBook Pro, Mac OS X (10.6.8)

Posted on Apr 17, 2015 2:43 PM

Reply

Answer 1

Best reply

Level 7

26,529 points

I do not think I would use Numbers for this task.

I would duplicate the file (let's say the name is data.txt)

and name the two files:

dataA.txt

dataC.txt

then I would open dataA.txt in TextEdit and delete the last half of the file and save

then I would open dataC.txt in TextEdit and delete the first half of the file and save

then duplicate dataA.txt and name the new file dataB.txt

then duplicate dataC.txt and name the new file dataD.txt

Now open dataA.txt and delete the last half of the file, save

Now open dataB.txt and delete the first half of the file, save

Now open dataC.txt and delete the last half of the file, save

Now open dataD.txt and delete the first half of the file, save

if you did this very often I would suggest a script of some kind

Reply