Split text by columns in PowerShell

by

Honestly I’d look up a better way to do this, but you can fudge it with some text manipulation and the ConvertFrom-Csv cmdlet:

$(qwinsta.exe) -replace "^[\s>]" , "" -replace "\s+" , "," | ConvertFrom-Csv | select username

Firstly replace any leading spaces or > characters with nothing, then replace any white spaces with a comma. Then you can pipe to ConvertFrom-Csv and work with the data as an object.

EDIT

Actually, the above has some issues, mostly with the \s+ because if a column is blank it does not get correctly recognised as a blank field, and the next text is incorrectly promoted to the current field.

The below is a full blown parser for this command, and would probably work for any sort of tabulated output from a native windows exe:

$o = @()
$op = $(qwinsta.exe)

$ma = $op[0] | Select-String "(?:[\s](\w+))" -AllMatches
$ErrorActionPreference = "Stop"

for($j=1; $j -lt $op.length; $j++) {
    $i = 0
    $obj = new-object pscustomobject
    while ($i -lt $ma.matches.count) { 
      $prop = $ma.matches[$i].groups[1].value; 
      $substrStart = $ma.matches[$i].index 
      $substrLen = $ma.matches[$i+1].index - $substrStart
      try {
        $obj | Add-Member $prop -notepropertyvalue $op[$j].substring($substrStart,$substrLen).trim() 
      }
      catch [ArgumentOutOfRangeException] {
        $substrLen = $op[$j].length - $substrStart 
        if($substrLen -gt 0) {
          $obj | Add-Member $prop -notepropertyvalue $op[$j].substring($substrStart,$substrLen).trim()
        }
        else {
          $obj | Add-Member $prop -notepropertyvalue ""
        }
      }
      $i++
    }
    $o += ,$obj
}

$o | ? { $_.type -eq 'rdpwd'} | select username

USERNAME
--------
user.name1
user.name2
user.name3

More Related Contents:

  1. PowerShell expression
  2. Awk – replace coumn 2 in table 1 from coumn 2 in table 2 based on matching data in column 1 (common between tables)
  3. Find and kill a process in one line using bash and regex
  4. Why doesn’t `\d` work in regular expressions in sed? [duplicate]
  5. powershell: how to escape all regex characters from a string
  6. Multiline regex to match config block
  7. AWK: Access captured group from line pattern
  8. Use a function in Powershell replace
  9. How to print matched regex pattern using awk?
  10. Find numbers after specific text in a string with RegEx
  11. How to use awk variables in regular expressions?
  12. How to match a pattern given in a variable in awk?
  13. Sed to extract text between two strings
  14. How to capture multiple regex matches, from a single line, into the $matches magic variable in Powershell?
  15. powershell extract text between two strings
  16. Multiline Regex in PowerShell
  17. Powershell script to remove double quotes from CSV unless comma exists inside double quotes
  18. How do you match only valid roman numerals with a regular expression?
  19. Validating IPv4 addresses with regexp
  20. What flavor of Regex does Visual Studio Code use?
  21. Jmeter extracting fields/parsing JSON response
  22. How to back reference “inner” selections ( () ) in a regular expression?
  23. Regular expression – PCRE does not support \L, \l, \N, \P,
  24. mod_rewrite: replace underscores with dashes
  25. Match at every second occurrence
  26. regular expression capture nth match
  27. What regex will match every character except comma ‘,’ or semi-colon ‘;’?
  28. Regex that matches integers in between whitespace or start/end of string only
  29. Nginx location “not equal to” regex
  30. Bash – Regex for HTML contents

Leave a Comment