How to convert string to table or objects in powershell

Question

How can I convert the below exported text to csv so that i can use it as objects in powershell. Eg:

where{$_.qlimit -eq 27}

Text:

  samid            qlimit    qused  
  Administrator    -1        0      
  Guest            -1        0      
  admin            27        8      
  krbtgt           -1        0      
  r                -1        0      
  admin2           44        0

Now I think the last edit does not reflect the real input data : ) — sodawillow, Jun 26 '16 at 08:34

Martin Brandl · Accepted Answer · 2016-06-26T08:21:48.990

6

Use the Get-Content cmdlet to load the file, replace two or more whitespaces with a comma and convert it to CSV using the ConvertFrom-Csv cmdlet:

$object = (Get-Content 'your_file').Trim() -replace '\s{2,}', ',' | ConvertFrom-Csv

If you now query your object:

$object | where qlimit -eq 27

You get the desired output:

samid qlimit qused
----- ------ -----
admin 27     8

edited Jun 26 '16 at 08:21

answered Jun 26 '16 at 07:37

Martin Brandl

56,134
13
133
172

No i am getting the below error.. PS C:\Users\Administrator> $object = (Get-Content c:\temp.txt) -replace '\s{2,}', ',' | ConvertFrom-Csv ConvertFrom-Csv : Cannot process argument because the value of argument "name" is invalid. Change the value of the "name" argument and run the operation again. At line:1 char:77 + $object = (Get-Content c:\temp.txt) -replace '\s{2,}', ',' | ConvertFrom-Csv <<<< + CategoryInfo : InvalidArgument: (:) [ConvertFrom-Csv], PSArgumentException + FullyQualifiedErrorId : Argument,Microsoft.PowerShell.Commands.ConvertFromCsvCommand – vinu Jun 26 '16 at 07:39
I cannot reproduce this. can you upload the text file? – Martin Brandl Jun 26 '16 at 07:54
Martin, It worked .. thanks..please see my following code: $object = $users -replace '\s{3,}', ',' | ConvertFrom-Csv $object | where {$_.samid -eq "r"} $object where $_.qlimit -eq 44 – vinu Jun 26 '16 at 08:21
Fine, but you should use `.Trim()` (see my updated answer). Also, please consider to accepting the answer. – Martin Brandl Jun 26 '16 at 08:22
where should i use trim? – vinu Jun 26 '16 at 08:23
Thank you for the great answer, it worked for me. I slightly modified this code to convert the rows from the table to object properties. Sample code: $header = "Property", "Value" $collection = $stringTable.Trim() -replace '\s{2,}', ',' | ConvertFrom-Csv -Header $header and now I can do this: $collection | ForEach-Object {Write-Host "Do something with $($_.Property) and $($_.Value)"} – Stoimen May 09 '19 at 12:06

score 2 · Answer 2 · answered Nov 20 '18 at 20:38

You can easily convert your table to PowerShell objects using the ConvertFrom-SourceTable cmdlet from the PowerShell Gallery:

ConvertFrom-SourceTable '
  samid            qlimit    qused  
  Administrator    -1        0      
  Guest            -1        0      
  admin            27        8      
  krbtgt           -1        0      
  r                -1        0      
  admin2           44        0  
' | Where-Object {$_.qlimit -eq 27}

Result:

samid qlimit qused
----- ------ -----
admin 27     8

score 0 · Answer 3 · answered Jun 21 '17 at 21:50

0

Another way with ConvertFrom-String (no headers in the file):

(Get-Content 'your_file').trim() | ConvertFrom-String -PropertyNames samid,qlimit,qused

answered Jun 21 '17 at 21:50

js2010

23,033
6
64
66

How to convert string to table or objects in powershell

3 Answers3

Linked