PowerShell - extracting text into variables (RegEx?)

Question

I have a PS script that pulls some status information from a switch. The output looks like this:

     8    Auto       Unknown        -1  Class 4      On     Good      3.29       47.75        68.96

I now need to assign these strings to variables, for further processing. I'm guessing RegEx would be the best (only?) way to do it, but I don't have the first clue on how to achieve that, so any suggestion will be gratefully received.

Cheers,

B.

The text is stream return from an SSH command. The stream is assigned to a variable, which I ran through a write-host, just to create the sample when asking the question. — Brian
– Brian, Commented Apr 7, 2020 at 11:38

mklement0 · Accepted Answer · 2020-04-07 13:24:18Z

2

Since the fields seem to be separated by varying numbers of spaces, it is simplest to use the unary form of -split, the string splitting operator:

# Sample input.
$line = @'
     8    Auto       Unknown        -1  Class 4      On     Good      3.29       47.75        68.96
'@

# Split the line into an array of fields by whitespace.
$fields = -split $line

# Output the result.
$fields

If you additionally want to infer the data types of the fields, simply by seeing if they can be converted to an integer ([int]) or a floating-point value ([double]):

foreach ($i in 0..($fields.Count-1)) {
  if ($newValue = $fields[$i] -as [double]) { $fields[$i] = $newValue }
  if ($newValue = $fields[$i] -as [int])    { $fields[$i] = $newValue }
}

edited Apr 7, 2020 at 13:24

answered Apr 7, 2020 at 11:36

mklement0

452k68 gold badges727 silver badges986 bronze badges

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

Collectives™ on Stack Overflow

PowerShell - extracting text into variables (RegEx?)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related