creating a new file by exporting

Computing.Net > Forums > Windows 2000 > creating a new file by exporting

creating a new file by exporting

Original Message

Name: Rob Freeman
Date: August 27, 2003 at 09:39:13 Pacific
Subject: creating a new file by exporting
OS: win2000
CPU/Ram: 2.4

Comment:

I have a 6 gig data file that is a database dump of records. What I need to do is get particular line numbers from this dump file that failed the import into a database. My problem is that I have been using this command:
sed -n -e 10004772P posdata.d >> rob.txt
While this will get out my line number, I have do go through the 6 gig file over and over for each record. Each line is taking about 15 minutes each. I have over 6000 to do.
Does anyone know of a way to get all the lines from this file with just one pass through the file?
I do have a file that has each line number I have to get from the large file. It looks like:
9911266
9911374
9911693
etc, etc
I did try to use a qbasic file I created to get the lines, but the 6 gig file is too large.
Any ideas?
Rob

Report Offensive Message For Removal


creating a CAT file for device drivers New files into a shared folder Create a Batch file to stop SMTP vi create a new workgroup and rights creating a batch file	Create a Batch file Setting vars in a batch file BY THE Creating a new user name and password in Creating a Dual Boot Partition Proper way to secure a new file ser

Server service is missing

SiS 730s

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: creating a new file by exporting

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

How often do you use Computing.Net?

Poll Finishes In 3 Days.
Discuss in The Lounge

Copernic Desktop Search BSOD

Another Clueless In Need of Help

VM Win Server 2003 Admin password

Connecting Vista to an XP network

XP won't let me log in

All Posts Awaiting Replies