DosTips.com

vsmeruga

Understood about when to use quote Thanks. I would like to understand this command what it is exactly doing?. for eg: In future, If I have to remove some other field instead of "ID" field 1.what does "o:2:-2" represent?. Is it same for what ever field I remove in the file? 2. *? ...

vsmeruga

Perfect. It worked. I got the findrepl.bat from drop box

Many Many Thanks..
Perfect. It worked. I got the findrepl.bat from drop box

Many Many Thanks..

vsmeruga

Hi I copied the code from the below link and created findrepl.bat and got the below error. My file.csv looks like below http://www.dostips.com/forum/viewtopic.php?f=3&t=4697&hilit=FINDREPL.BAT F:\>type "file.csv"|findrepl /o:2:-2 |findrepl "(.*?,.*?, .*?,).*?,(.*)" "...

vsmeruga

Hi I do not have access to dropbox and I could not get the file( repl.bat) instead I found another link in the net as below and I tried creating a batch file(repl.bat) based on it but not succeded. Error came as shown as below Please correct me what I have done wrong. Thanks Sheku m F:\>type "...

vsmeruga

Hi foxidrive

This is the example data I have provided. I get more rows every day in a single file with header and footer. I believe the solution provided to me will work for more rows

vsmeruga

Thank you very much. I will try it and respond back.

vsmeruga

Yes. fields can be empty.

vsmeruga

ID - 1.1112E+11 - is a 11 digit number

vsmeruga

Hi Sorry for the delayed reply . File looks like below, it is a .csv file, I should remove header, trailer and "ID" field with value from the file. 0HEADER20140930-100111,,,,,,, Date,Exch,Product,ID,Price,Multiplier,Account,Tax 20140930,20Y ,ABC ,1.1112E+11,1000,10,12347890,30 9TRAILER0000...

vsmeruga

Hello

I am an Architect and not a windows batch scripter and I need help to write a small script to remove header and footer of a csv file located in a specific directory and also I should remove an unwanted field from the list of fields.

Please help me on this .

Many Thanks
sheku

vsmeruga

Thanks Squashman.

vsmeruga

This modified code worked. But the filesize is showing as 8 KB(not 0 KB). When I open each file, Column A is selected in sheet1.

vsmeruga

Hi 1.) I have created empty xlsx file named(EmptySheet.xlsx ) and placed in F:\test folder. 2.) And all my 12 .xlsx files which has to be emptied are placed in the same folder. 3.) the batch script also placed in the same folder and it has below code When I run it nothing happens. Please assist on ...

vsmeruga

Okay I will try with empty excel sheet.

Thanks
VJ

vsmeruga

Listed 12 files in 12 rows(Col A) and named the file as EmptySheet.xlsx

DosTips.com

Search found 35 matches

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Re: Removing header and trailer row, removing field in csv f

Removing header and trailer row, removing field in csv file

Re: Removing data/making empty - the list of files in a fold

Re: Removing data/making empty - the list of files in a fold

Re: Removing data/making empty - the list of files in a fold

Re: Removing data/making empty - the list of files in a fold

Re: Removing data/making empty - the list of files in a fold