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
– sodawillow, Commented Jun 26, 2016 at 8:34

Martin Brandl · Accepted Answer · 2016-06-26 08:21:48Z

7

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, 2016 at 8:21

answered Jun 26, 2016 at 7:37

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

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

6 Comments

Vinod Over a year ago

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

Martin Brandl Over a year ago

I cannot reproduce this. can you upload the text file?

Vinod Over a year ago

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

Martin Brandl Over a year ago

Fine, but you should use .Trim() (see my updated answer). Also, please consider to accepting the answer.

Vinod Over a year ago

where should i use trim?

|

iRon · Accepted Answer · 2018-11-20 20:38:28Z

2

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

answered Nov 20, 2018 at 20:38

iRon

24.4k10 gold badges60 silver badges107 bronze badges

Comments

js2010 · Accepted Answer · 2017-06-21 21:50:20Z

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, 2017 at 21:50

js2010

28.3k6 gold badges82 silver badges88 bronze badges

Collectives™ on Stack Overflow

How to convert string to table or objects in powershell

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related