Powershell - Get Last 3 char from AD attribute in PsObject

Question

I got a script which export to csv some AD attributes I want to have the last 3 characters of the 'initials' attribute in a PsObject but i have an error and i spent Hours on this... Could you help me ?

The Error:

*Method invocation failed because [Microsoft.ActiveDirectory.Management.ADUser] doesn't contain a method named 'substring'.
At C:\scripts\ExtractDWH\Untitled2.ps1:15 char:26
+                 "Test" = $_.substring <<<< ($_.initials.length - 3, 3)
    + CategoryInfo          : InvalidOperation: (substring:String) [], RuntimeException
    + FullyQualifiedErrorId : MethodNotFound*

The Code :

 $output = 'c:\scripts\ExtractDWH\consultants_test.csv'
 $users = Get-ADUser -Filter * -SearchBase "ou=Rennes,ou=Consultants,ou=Utilisateurs,ou=FedFinance,dc=dfedinterim,dc=fr" -     Properties *  | ? { ($_.initials -notlike 'IC*') -and ($_.initials -notlike 'IM*') -and ($_.initials -ne $null) }
      fileIn | % {
        $users | % { 
           New-Object psobject -Property @{
               "ID" = $_.initials
               "Last 3 strings ID" = $_.substring($_.initials.length - 3, 3) 
               "Centre Imputation" = $_.extensionAttribute10
               "Date Entrée" = $_.extensionAttribute9
                # The line below does not work                 
               "Test" = $_.substring($_.initials.length - 3, 3) 
             }
         }
     } | Select-Object ID, 'Centre Imputation', 'Date Entrée', 'Test' 
 | Export-CSV $output -Delimiter ';' -Encoding "UTF8" -NoTypeInformation    `

Thank you !

Note: -properties * is not really a good idea as it gets every single ad attribute that would exist. Instead list out the properties that you want like so: `-properties Initials,extensionAttribute10,extensionAttribute9` — Kiran Reddy, Apr 12 '16 at 09:34

score 2 · Answer 1 · answered Apr 12 '16 at 09:33

2

Change this:

"Last 3 strings ID" = $_.substring($_.initials.length - 3, 3)

To This:

"Last 3 strings ID" = $_.initials.substring($_.initials.length -3, 3)

answered Apr 12 '16 at 09:33

Avshalom

8,657
1
25
43

It Works also perfect ! Thanks a lot – olivier Apr 12 '16 at 09:56

Martin Brandl · Answer 2 · 2016-04-12T09:48:40.993

2

Avshalom showed you the error. You can also use the following to access the last 3 characters:

"Test" = $_.initials[-3 .. -1] -join ''

edited Apr 12 '16 at 09:48

answered Apr 12 '16 at 09:36

Martin Brandl

56,134
13
133
172

Should it be more like `"Test"[-3 .. -1] -join ""` to get rid of the array? – Martin Apr 12 '16 at 09:46
It Works perfect ! Thanks – olivier Apr 12 '16 at 09:56

Powershell - Get Last 3 char from AD attribute in PsObject

2 Answers2