summary from multiple text files in folder

[DingDang]

I have multiple text files in folder in which there is row start from "Total"
I want batch file which get all row of file start from Total in one file also start from file name
e.g
file name in folder c:\text\ file name 1.txt, 2.txt,3.txt.....so on

result required in seprate file which auto save as summary.txt in same foleder.

file name total
1.txt 12121.00
2.txt 23232.00
3.txt 454545.00

Pls help

[Aacini]

Code: Select all

@echo off
( for %%a in (*.txt) do (
   for /F "tokens=2" %%b in ('findstr "Total" "%%a"') do echo %%a  %%b
) ) > summary.tmp
ren summary.tmp summary.txt

[DingDang]

Gre8..Thanks a lot for code.

but, one more help required in summary file entire row not copying. txt file contain below data which start from Total.

TOTAL: 71 15,74,786.00 97 1,14,06,129.35
TOTAL: 3 15,80,696.70 1,262 81,31,483.87

it should copy entire row. pls help
requried details in summary file should as below

1.txt TOTAL: 71 15,74,786.00 97 1,14,06,129.35
2.TXT TOTAL: 3 15,80,696.70 1,262 81,31,483.87

[foxidrive]

This returns the text below it. Is that any good?

Code: Select all

@echo off
findstr /i "^TOTAL:" *.txt >summary.txt

1.txt:TOTAL: 71 15,74,786.00 97 1,14,06,129.35
2.txt:TOTAL: 3 15,80,696.70 1,262 81,31,483.87

[DingDang]

Dear foxidrive.

u r simply the great...its work.

Thanks a lot.