Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Programming > delete headers line

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

delete headers line

Reply to Message Icon

Name: lklo330
Date: September 18, 2009 at 11:07:31 Pacific
OS: Windows XP
Product: Amd Athlon ii x2 dual core processor
Subcategory: General
Comment:

Hi All,

I have a little problem...

i have a lot of txt files like this

NAME NUMBER
Jonh 157
Tom 198

and i want to create only one file containing all the data without the headline been repeated

ps. i would like to open it with excel also

regards,

Paul.



Sponsored Link
Ads by Google

Response Number 1
Name: Mechanix2Go
Date: September 18, 2009 at 11:19:05 Pacific
Reply:

@echo off & setLocal EnableDELAYedExpansion

> newfile echo NAME NUMBER


for /f "tokens=* delims= " %%a in ('dir/b/a-d *.txt') do (
for /f "skip=1 tokens=* delims= " %%i in (%%a) do (
>> newfile echo %%i
)
)


=====================================
Helping others achieve escape felicity

M2


0

Response Number 2
Name: lklo330
Date: September 18, 2009 at 11:45:12 Pacific
Reply:

thank you very match
both for the code and for reply so quickly


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Automate Dell Tag detail ... doubt in batch file


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: delete headers line
Delete blank lines with batch file? www.computing.net/answers/programming/delete-blank-lines-with-batch-file/13018.html

Delete blank lines from a text file www.computing.net/answers/programming/delete-blank-lines-from-a-text-file/14525.html

deleting multiple lines in multiple text file www.computing.net/answers/programming/deleting-multiple-lines-in-multiple-text-file/19862.html