DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Software

Reply
 
Thread Tools Display Modes
Old 08-24-2011, 03:07 AM   #1
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default One line plus one million lines

Perhaps there is a better way than a text editor for my real objective: Take one line of tab delimited text, add one million lines of comma delimited text, and use the result as input for MS Access 2010.

DOS Command:

copy 1line.txt + 1000000lines.txt result.txt

as a possibility. Can I do a DOS command in Windows 7? If not, maybe in the command window on Windows XP Pro.
dthomsen8 is offline   Reply With Quote
Old 08-24-2011, 05:04 AM   #2
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,709
Default

The command prompt for Win7 is in pretty much the same place it's always been: Start | All Programs | Accessories

Or press Windows Key + R to get the RUN box and type your command into it or type CMD to get a command prompt.

Will Access know what to do with mixed tab delimited and csv data? You might need to convert the first line to CSV also.

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Old 08-24-2011, 05:56 AM   #3
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default Mixed data? Not really.

Quote:
Originally Posted by Steve Rindsberg View Post
The command prompt for Win7 is in pretty much the same place it's always been: Start | All Programs | Accessories

Or press Windows Key + R to get the RUN box and type your command into it or type CMD to get a command prompt.

Will Access know what to do with mixed tab delimited and csv data? You might need to convert the first line to CSV also.
I am creating the first line, so I can match it with the characteristics of the million line file. I have two of them, from different sources, with somewhat different characteristics. Thank you for the details. I am sometimes lost in Windows 7 when I should not be, it is enough like Windows XP Pro to find most things.
dthomsen8 is offline   Reply With Quote
Old 08-24-2011, 07:12 PM   #4
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,709
Default

Quote:
Originally Posted by dthomsen8 View Post
I am creating the first line, so I can match it with the characteristics of the million line file. I have two of them, from different sources, with somewhat different characteristics. Thank you for the details. I am sometimes lost in Windows 7 when I should not be, it is enough like Windows XP Pro to find most things.
Sure, but if the data itself is CSV, shouldn't the "header" record (ie, first line) be in the same format?

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Nearly one million words Richard Waller On Language & Literature 11 06-13-2009 05:17 AM
Brad and...how many million Harry Potter?? ElyseC The Corner Pub 37 10-13-2007 01:38 AM
Dead Lines PeterArnel The Corner Pub 2 04-01-2007 02:18 PM
Firefox reaches 100 million Kelvyn The Corner Pub 13 10-25-2005 12:27 PM
Brad & Harry Potter's 10.8 million copies ElyseC The Corner Pub 60 07-31-2005 07:53 AM


All times are GMT -8. The time now is 07:43 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.