Powershell Select-String -ExactMatch?

Question

Im trying to find a way using Select-String and search for exact match in a file, and get all the lines that contains this exact match in exact colum. Example Snippet from data file:

08/25/2021 11:56:03 muzi.puzi 123 Bla
08/25/2021 19:56:03 bla.bla 1234 Bla
08/25/2021 19:56:03 abc.def 54 bla123

Function Get_User_Dates_From_DBFile ([int] $Num, [string] $Db_File){
    #Rereive all the dates in DataFile BiometricNum has signed on or off
    $Dates = gc $Db_File | Select-String -Pattern "^$BioMetric_Num" 
    Return ($Date | Sort | Get-Unique) 
}

Get_User_Dates_From_DBFile 123 $Db_file

This will give me all Three lines, I want to make sure that it doesnt catch anything more than that (Example 1234) and also make sure it doesnt catch 123 at the end of the last line, as the nubers is refering only to the 4th colounm

Any Advice would be great, Thanks

Define: "exact match". I guess you mean a whole word that bound by word bounderies: "\b$num\b" — iRon
– iRon, Commented Aug 24, 2021 at 7:27

Dennis · Accepted Answer · 2021-08-25 15:53:45Z

1

I'm not sure why you are using the roof sign before the variable...
But this pattern will eleminate wrong 123

'08/25/2021 11:56:03 muzi.puzi 123 Bla
08/25/2021 19:56:03 bla.bla 1234 Bla
08/25/2021 19:56:03 abc.def 54 bla123' > file.txt

$BioMetric_Num = '123'

Get-Content .\file.txt | Select-String -Pattern " $BioMetric_Num "

So in your case, your current function should be able to work correctly using

Get_User_Dates_From_DBFile ' 123 ' $Db_file

edited Aug 25, 2021 at 15:53

answered Aug 25, 2021 at 15:47

Dennis

2,1282 gold badges20 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Powershell Select-String -ExactMatch?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related