Removing header and trailer row, removing field in csv file

[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..

[Squashman]

Why do you keep quoting yourself in all of your posts.

Quoting is for when you are using part of someone else post.

[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. *? - : this *? is in 4th position as I have to remove my 4th field ID .

your help understanding it is most appreciated.
Thanks

type "file.csv"|findrepl /o:2:-2 |findrepl "(.*?,.*?,.*?,).*?,(.*)" "$1$2"

[foxidrive]

1.what does "o:2:-2" represent?

It filters the file and shows only from line 2 to the 2nd last line.

2. *? - : this *? is in 4th position as I have to remove my 4th field ID .

This uses regular expressions and it removes the text from after the third comma, until the 4th comma inclusive, in each line.