Check if a string exists in a .CSV file and if it doesn't then append it using Powershell

Question

I have a .csv file that uses 2 columns that both have headings: Teacher,Channel

Below the teacher column sits the teachers username and below the Channel column sits the teachers assigned Channel.

I am trying to get a script working that will check through the .csv for the logged on teachers username and then reply with their channel and if their username doesn't exist then append it and assign it a channel that is 1 number higher than the previous teachers channel. Once the script has added the new username of the logged on user it should use their newly assigned channel.

So far I have this:

$strCSV = "\\SEVERNAME\SHARE\FOLDER"
$strCurrentUser = Get-WmiObject -Class Win32_ComputerSystem
$strChannel = Import-Csv $strCSV\teachers.csv | where {$_.Teacher -eq $strCurrentUser.UserName.TrimStart("DOMAIN\")} | % channel

It's not much, but I am really new to Powershell, so any help would be amazing please.

Dane Boulton · Accepted Answer · 2014-09-02 15:42:22Z

3

something like this would work. it imports the CSV checks for the existing user. If found do stuff else if not found it gets last channel adds one and exports the new teacher to the end of the file.

$file = "\\SEVERNAME\SHARE\FOLDER\teachers.csv"
$teachers = Import-Csv $file
$strCurrentUser = (Get-WmiObject -Class Win32_ComputerSystem).UserName.TrimStart("DOMAIN\")
$strChannel = $teachers | where {$_.Teacher -eq $strCurrentUser} | % channel
if($strChannel){
#dostuff with channel
}
else{
$lastChannel = [int]$teachers[$teachers.length-1].channel + 1
"{0},{1}" -f $strCurrentUser,$lastChannel | add-content -path $file
}

answered Sep 2, 2014 at 15:42

Dane Boulton

1,3251 gold badge11 silver badges15 bronze badges

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

2 Comments

Random206 Over a year ago

Thanks Dane, Could you explain to me please what the "{0},{1}" -f part does please, I have seen this around before but don't really understand why it's there and would rather know for sure than guess please.

Dane Boulton Over a year ago

"{0},{1}" -f is just a format operator. so basically saying format the the output as "$strCurrentUser,$lastChannel" then add it to the end of the file. Since your file is just a two column comma separated csv it should match up just fine. If you wanted it in different format like var1-var2 you could do "{0}-{1}" -f see this ms article for a bit more info if you like: social.technet.microsoft.com/wiki/contents/articles/…

Collectives™ on Stack Overflow

Check if a string exists in a .CSV file and if it doesn't then append it using Powershell

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