findstr issue with multiple lines returned for containing part of search string

Question

Trying to find line in a file but an having an issue with the literal search string. When search for a string it is returning multiple line that where the search string is only part of the line. As an example, I am looking up comp1 in a list of computers and i am getting comp1 and comp1a being returned. Is there a way to just return the first and not the second, or is this a limitation of findstr. Code below

For /f %%a in (%home%\text.txt) do call :look1 %%a

:look1
 set lookup=%1
 findstr /i /c:%lookup% %home%\data.csv >> %home%\final.csv
 exit /b

Edited to include sample of data.csv

Data.csv

date,comp,os,application

date,comp1,os,application

date,comp1a,os,application

date,comp2,os,application

Include the leading and trailing commas in your search term. — foxidrive
– foxidrive, Commented Jan 17, 2014 at 5:45

Magoo · Accepted Answer · 2014-01-17 06:21:23Z

1

I'd suggest

FINDSTR /r "^comp, ,comp$ ,comp," <qfindrsl.txt

would be the way to go. This matches on any of the regex expressions "^comp," (comp, at the start of the line), ",comp," (or this string) or ",comp$" (,comp at end-of-line.)

Edit : I put the data in qfindrsl.txt. That worked both with my test data and with the sample data provided.

If the data will not contain the target string at either the start or end of lines, this could be simplified to

FINDSTR /r ",comp," <qfindrsl.txt

edited Jan 17, 2014 at 6:21

answered Jan 16, 2014 at 4:48

Magoo

80.8k8 gold badges68 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hellobum Over a year ago

I should probably have put that data.csv file has the computer name in a line with lots of other data and it is not the first or last thing in the line.

Magoo Over a year ago

Representative sample data often clarifies matters. You can edit your question to include this.

foxidrive · Accepted Answer · 2014-01-16 04:33:58Z

0

You can use the regexp terms to limit the find filter:

^ indicates the start of a line
$ indicates the end of a line

 findstr /r "^comp1$" "filename.txt"

Another way is to use /b and /e in findstr

answered Jan 16, 2014 at 4:33

foxidrive

41.4k11 gold badges61 silver badges71 bronze badges

Collectives™ on Stack Overflow

findstr issue with multiple lines returned for containing part of search string

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related