Windows findstr with AND condition

Question

Hi i searched few older posts but didnt find exact solution. so posting new question.

I need a single a windows command to search two words using AND condition. Will findstr works for combination of words? im searching for WORD1 followed by WORD2.( not in reverse. word2 followed by word1 or single word).

Below one is sample file contents:

TABLEA
insert
INSERT TABLEA
update tableA
upsert tableb
insert into tableA
update staging.tableA
insert into staging.tableA
-- insert into staging.tableA
test insert staging.tableA
tableA insert
tableA select insert

Desired Search Output: prints the filename when match is found. fr example, word1=insert and word2=tableA. below are the sample search results

INSERT TABLEA
insert into tableA
insert into staging.tableA
-- insert into staging.tableA
test insert staging.tableA

And i have thousands of files to search and huge in size. i need filenames which contains the match of two words.

I tried using findstr command. but not succeeded.Is there any equivalent command to use in batch file?

Thanks in advance.

Answer 1

Given your exemple i was able to produce the expected result :

type sample.txt | FINDSTR /I "insert.*.tableA"

Assuming :

• sample.txt contains the sample file content you provided
• word1=insert and word2=tableA in correct AND order ("insert.*.tableA")
• insensitive case (/I) to match INSERT TABLEA

I've not tested every use cases, but should be a good start for you to improve.

From now, it's up to you to parse some rules files and pass variables to the command above, this is another story but not a findstr issue.