Batch File for Deleting Lines and Charecters

Microsoft Windows xp professional sp2c e...
June 9, 2010 at 17:12:38
Specs: Windows XP
Hi Experts,

I have a file format as mentioned below. I
would like to have Batch script (Win XP) which
can:

1. Remove first 6 and last 3 lines of the file placed in D:/Test directory.
2. Delete the lines where 3rd column which
has value as Alpha Numeric
3. Delete the lines where 4th column having
0.00
4. Should delete all cotes (")

Sample File Snippet

"RPT TRIALB ABC LIMITED"
"TRIAL BALANCE"
"FOR THE PERIOD ENDED DECEMBER 2009"
""
""
""
"1","Bank1","1234",100.00,XYZ
"2","Bank2","ABC1234",200.00,XYZ
"3","Bank3","1234",0.00,XYZ
"4","Bank4","CDE1234",400.00,XYZ
"5","Bank5","1234",500.00,XYZ
"","","",,,,
"","","",,,,
"END OF REPORT"

Output should be like this.

1,Bank1,1234,100.00,XYZ
5,Bank5,1234,500.00,XYZ

Thanks,
Phani Akella


See More: Batch File for Deleting Lines and Charecters

Report •

#1
June 9, 2010 at 23:30:41
This should be posted here for more help:

http://www.computing.net/forum/prog...


Report •
Related Solutions


Ask Question