Blog GL2i

User Tools

Site Tools

Trace:
en:powershell:start

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:powershell:start [2021/03/09 22:34] – lonclegren:powershell:start [2021/03/16 21:48] (current) – lonclegr
Line 3: Line 3:
 ===== Basics ===== ===== 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. Here is an example of CSV input file.
Line 25: Line 25:
 Import-Csv -Path input.csv | foreach { Import-Csv -Path input.csv | foreach {
  
-    # save current object into different variable+    # save current object into a local variable
     $currentLine = $_     $currentLine = $_
  
Line 31: Line 31:
     $mail = $currentLine.Mail     $mail = $currentLine.Mail
  
-    # test domain mail+    # test mail domain name
     # we add a property with the result of our test     # we add a property with the result of our test
     if ($mail -match "domain.com$") {     if ($mail -match "domain.com$") {
Line 45: Line 45:
 Export-Csv -Path preCheck.csv -NoTypeInformation Export-Csv -Path preCheck.csv -NoTypeInformation
 </file> </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>
en/powershell/start.1615347286.txt.gz · Last modified: 2021/03/09 22:34 by lonclegr