Differences

This shows you the differences between two versions of the page.

--- en:powershell:start [2021/03/07 22:31] – lonclegr
+++ en:powershell:start [2021/03/16 21:48] (current) – lonclegr
@@ Line 3: / Line 3: @@
 ===== Basics =====
-According to me, the first thing we need to deal with is CSV file. First let's read one CSV file, loop over it.
+To me, the first thing we need to learn is to deal with is CSV file. First let's read a CSV file, loop across the lines.
 Here is an example of CSV input file.
@@ Line 11: / Line 11: @@
 abc123,abc123@domain.com
 def123,def123@domain.com
+ghi123,ghi123@test.com
 </csv>
@@ Line 17: / Line 18: @@
 abc123,abc123@domain.com
 def123,def123@domain.com
+ghi123,ghi123@test.com
 </file>
-<file powershell csv.ps1>
+<file powershell csvLevel1.ps1>
 Import-Csv -Path input.csv | foreach {
-  # save current object into different variable
+    # save current object into a local variable
-  $currentLine = $_
+    $currentLine = $_
-  # deal with columns
-  $sam = $currentLine.Samaccountname
-  # let's see if the user exists into AD
-  try {
-    $user = Get-ADUser -identity $sam
-    # user found
-  } catch {
-    # user not found, maybe user is disabled for instance ?
-  }
-}
+    # deal with columns
+    $mail = $currentLine.Mail
+    # test mail domain name
+    # we add a property with the result of our test
+    if ($mail -match "domain.com$") {
+        $currentLine | Add-Member -MemberType NoteProperty -Name "domainCheck" -Value "valid"
+    } else {
+        $currentLine | Add-Member -MemberType NoteProperty -Name "domainCheck" -Value "invalid"
+    }
+    # return updated currentLine with new column
+    $currentLine
+} |
+# export result line by line to CSV
+# -NoTypeInformation prevents metadata from being exported
+Export-Csv -Path preCheck.csv -NoTypeInformation
 </file>
+This script will output CSV file with a new column.
+<file csv preCheck.csv>
+"Samaccountname","Mail","domainCheck"
+"abc123","abc123@domain.com","valid"
+"def123","def123@domain.com","valid"
+"ghi123","ghi123@test.com","invalid"
+</file>
+<csv>
+"Samaccountname","Mail","domainCheck"
+"abc123","abc123@domain.com","valid"
+"def123","def123@domain.com","valid"
+"ghi123","ghi123@test.com","invalid"
+</csv>