powershell csv unable to search

Question

I'm trying to learn basic powershell loops on CSV files. Tried many tutorials or guides online but no avail. Hope you guys can help. Thanks

Here's my CSV file

Tried to loop through it to look for vpn_name and display the key but seems it won't find what I'm looking for. The path is correct since I tried to display what's inside $c.'vpn_name' displays list from test to test3.

$csv = import-csv -Path "path.csv"
foreach ($c in $csv) {
    $c.'vpn_name' -contains 'test'
}

Hope you guys can help. Really appreciate it. Thanks

the -contains operator is for collection objects and requires an exact match. to match test1 with test you must either use the -match regex operator OR the -like wildcard string operator ... with wildcard chars. — Lee_Dailey
– Lee_Dailey, Commented Jan 25, 2022 at 6:06

navylover · Accepted Answer · 2022-01-25 07:34:36Z

1

Firstly, the csv file format is:

vpn_name,vpn_key
test,lksajdlksja
test1,lksajdlksja
test2,lksajdlksja

Secondly, use the following to search:

   foreach ($c in $csv) {
        $c.'vpn_name' -like '*test*'   //All three rows of the csv file return true.
    }

    foreach ($c in $csv) {
        $c.'vpn_name' -contains 'test'   //Only first row of the csv file return true.
    }

About your another question, please replace

'*$username*'

with

'*'+$username+'*'

edited Jan 25, 2022 at 7:34

answered Jan 25, 2022 at 6:04

navylover

13.9k5 gold badges33 silver badges44 bronze badges

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

2 Comments

Xavier Johanis Over a year ago

can you share what's the difference? Thanks

Xavier Johanis Over a year ago

tried using below getting same result

$username = Read-Host "Enter username " foreach ($c in $csv) {     if ($c.'vpn_name' -like '*$username*') {         write-host $c.'vpn_key'     } }

Collectives™ on Stack Overflow

powershell csv unable to search

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related