Solved

Dos Batch Program to Parse Text File

Posted on 2008-10-23
2
2,959 Views
Last Modified: 2008-10-24
I need to write a batch program that will scan a text file and write out the first 5000 lines that contain "000000000000".  The file contans around 14 million rows.
0
Comment
Question by:ddpleasant
2 Comments
 
LVL 38

Accepted Solution

by:
Shift-3 earned 500 total points
ID: 22789252
Paste the script below into a text file with a .cmd extension.  Customize the value of the file variable with the location of the text file.  Running the script will echo the first 5000 matching lines to the file specified in the output variable.

I've only been able to test this with a 100,000-line file.  It's quite possible that it will choke on one that's 14 million lines.  Special characters such as angle brackets, pipes, and ampersands will also give it trouble.


@echo off

setlocal enabledelayedexpansion
 

set file=c:\file.txt

set output=output.txt

set maxlines=5000
 

set count=0
 

for /F "tokens=* usebackq" %%G in ("%file%") do (

 if !count!==%maxlines% goto :eof

 

 set line=%%G

 set line=!line:*000000000000=--FOUND--!

 if "!line:~0,9!"=="--FOUND--" (

  echo %%G>>"%output%"

  set /a count+=1

 )

)

Open in new window

0
 

Author Comment

by:ddpleasant
ID: 22789340
You were right about it choking.  I received a mesage that stated not enough storage is available to process this command.

Thank you for the help though.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

We have adopted the strategy to use Computers in Student Labs as the bulletin boards. The same target can be achieved by using a Login Notice feature in Group policy but it’s not as attractive as graphical wallpapers with message which grabs the att…
Introduction: Recently, I got a requirement to zip all files individually with batch file script in Windows OS. I don't know much about scripting, but I searched Google and found a lot of examples and websites to complete my task. Finally, I was ab…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now