Findstr regexp

[Squashman]

All these years and I still do not understand Regular Expressions. Must need to be a Rocket Surgeon.

Just want all records where the 8th comma delimited field has store in it.
Tried this and it gave me records with the 8th field, but also records where store was in the 10th field.

Code: Select all

findstr /B /R ".*,.*,.*,.*,.*,.*,.*,Store," test.txt

[Squashman]

Understanding Regular Expressions is a fricken lost cause for me!!!!! Getting really pissed off because I can do this shit in SAS but can't seem to get the syntax right using FINDSTR or JREPL!

Neither of these worked.

Code: Select all

jrepl "(.*?,){7}Store," "" /b /f test.txt

jrepl ".*?,.*?,.*?,.*?,.*?,.*?,.*?,Store," "" /b /f test.txt

[aGerman]

Squashman

. is for "any character" where a comma is an "any character" as well
What you're looking for is "any character that is not a comma".
Try

Code: Select all

findstr /br "[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,Store," "test.txt"

Regards
aGerman

[dbenham]

It is even simpler when you have a a utility with a proper regex implementation that allows you to specify a match count.

Using JREPL:

Code: Select all

jrepl "^([^,]*,){7}Store,.*" "$0" /jmatch /f "test.xt"

Dave Benham

[Squashman]

Thanks guys!!! Helped out a lot.