Quicker method than findstr?

[SIMMS7400]

Hi Folks -

I have a file that's almost 7k rows.

I need ot remove all lines that begin with "PFP

So this is my code:

Code: Select all

findstr /v /i /b ""PFP" Input.csv > Output.csv

However it's taking forever. Anyway to speed this process up?

Thanks!

[batnoob]

Code: Select all

findstr /v /i /b ""PFP" Input.csv > Output.csv

However it's taking forever. Anyway to speed this process up?

Thanks!

if that is exactly what your code says, then take off the extra quote

Code: Select all

findstr /v /i /b "PFP" Input.csv > Outpu.csv

[SIMMS7400]

My strings are quoted in the file, hence why I need that.

"PFP is the string I"m searching for...

[aGerman]

As far as I remember you have to escape the quotation mark in a FINDSTR pattern.

Code: Select all

findstr /vib "\"PFP" Input.csv > Output.csv

Steffen

EDIT
Unbalanced quotes are always a mess. Could be you have to escape the last one using a caret.

Code: Select all

findstr /vib "\"PFP^" Input.csv > Output.csv

[SIMMS7400]

As far as I remember you have to escape the quotation mark in a FINDSTR pattern.

Code: Select all

findstr /vib "\"PFP" Input.csv > Output.csv

Steffen

EDIT
Unbalanced quotes are always a mess. Could be you have to escape the last one using a caret.

Code: Select all

findstr /vib "\"PFP^" Input.csv > Output.csv

Works like a charm! Thank you, S!