DosTips.com

hello guys

given below is my dos command

echo on
cd filelocation
echo umiya >umiya.xls
findstr /R /N "^" file.txt | find /C ":" >>umiya.xls



the execution is correct but the output is something like
umiya
10


i just need it in side by side like

umiya-10

A FOR /F loop enables you to output both the text and your line number.

Note that you don't create an Excel file even if you use the xls extension.

Regards
aGerman

or



or



.

Yury: thanks it worked

hello,

here is my code

cd desktop
e:


cd E:\CTS\Data\Mumbai\CORE\MEHSANA\OutBox\Extracts\IW

(
set /p="Meshana - "<nul
findstr /rn "^" "*25092014*.txt"| find /c ":"
)>"E:\counts\extract-count.xls"

cd ../../../../

cd E:\CTS\Data\Mumbai\CORE\Varachha Bank\OutBox\Extracts\IW


(
set /p="Varacha - "<nul
findstr /rn "^" "*25092014*.txt"| find /c ":"
)>>"E:\counts\extract-count.xls"
cd ../../../../

cd E:\CTS\Data\Mumbai\CORE\SURAT DIST CO-OP BANK\OutBox\Extracts\IW

(
set /p="surat-dist - "<nul
findstr /rn "^" "*250914*.txt"| find /c ":"
)>>>"E:\counts\extract-count.xls"

cd ../../../../

cd E:\CTS\Data\Mumbai\CORE\UMIYA\OutBox\Extracts\IW




(
set /p="umiya - "<nul
findstr /rn "^" "*25092014*.txt"| find /c ":"
)>>>>"E:\counts\extract-count.xls"

cd ../../../../



THE CODE MENTIONED ABOVE IS WRITING VALUES FOR FIRST 2 FILES CORRECTLY BUT FOR 3RD AND 4TH IT WAS NOT ENTERING ANY RECORDS AND ERROR APPEARING LIKE THIS IN DOS

> was unexpected at this time.



SOME ONE PLEASE HELP TO SOLVE THIS

i NEED OUTPUT LIKE


MESHANA-5269
VARACHA-2452
SURAT-5626
UMIYA-45

BUT THE MENTIONED CODE IS WRITING ONLY FIRST TWO RECORDS AND NOT FETCHNING RECORDS FROM 3RD ONE.

sivasriram wrote:THE CODE MENTIONED ABOVE IS WRITING VALUES FOR FIRST 2 FILES CORRECTLY BUT FOR 3RD AND 4TH IT WAS NOT ENTERING ANY RECORDS AND ERROR APPEARING LIKE THIS IN DOS

> was unexpected at this time.



SOME ONE PLEASE HELP TO SOLVE THIS

Change >>> to >>
and
Change >>>> to >>

sivasriram wrote:hello,

here is my code

How about using code tags when you post code.