Windows 10: Powershell string parsing

Lets say I have a string with several columns separated by spaces. The number of spaces and the data in each column are unknown. How would you grab what's in col3 using PowerShell? I know how I would do it with Awk, but that won't necessarily be available to me.

col1 col2 col3 col4

:)

 

Powershell - Need some help

Hi Everyone,

Currently I am pulling in data and parsing in powershell with a regex expression.

$regex = [regex]
"\b(??:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\b"

$ipAddress = $regex.matches($log) |
% { $_.value }

The variable becomes a string. I am looking for a way to convert the ip addresses into objects, that I can pass into a url.

$ipAddress =
$regex.matches($log) |
% { $_.value } | ConvertFrom-StringData
$IPAddress -OutBuffer
$ipAddressURL

This is the output currently shown when I run the $ipAddress variable in powershell. I have looked and googled left and right but I am unsure how to separate these into objects and not string in PS. Can someone help?

118.101.203.252

24.10.216.192

173.252.100.117

173.252.114.114
Thanks!

Third.

 

Network adapters not installing correctly or VPN's not installing properly on Win10?

I think your clue could be that that string was given under the word "commands". So, I would suspect that two lines were given as one. We can try parsing it out. The tip you got to check the reg delete syntax could be a good place to start.

Looks like the /va and /f would parse OK but the rest would not. So, I would try breaking off the rest into a second command, consistent with the impression given by the use of the word "commands".



Good luck

Robert Aldwinckle

---

 

Look at the split command.
Topic: Simulating awk in or equivalent in Select-String

 

The only issue with split is that I don't know how many spaces are between the columns. For instance, if I want what is in the third column, this example would not work.
Code: $a = "ABC 69278 DEF 10278" $a.Split()[2][/quote] I must Split twice
Code: $a = "ABC 69278 DEF 10278" $a = $a.Split() -ne"" $a.Split()[2][/quote] I feel like I'm overcomplicating things and this could be simplified somehow. Is there a better way?

 

Hi Jnich,

There are two ways you should approach this string splitting: by using the second parameter of the .Split() method, or by using the -split operator.

The .Split() .NET method of the string type has six overloads, one of which allows you to specify [System.StringSplitOptions]::RemoveEmptyEntries after the string you wish to split by.
Code: $a.Split(' ', [System.StringSplitOptions]::RemoveEmptyEntries)[/quote]
The second way, which is shorter and more PowerShell-ic, is to use the -split operator. It’s typical use involves two arguments on either side of the operator, e.g., $a -split ' ', but if you do this you’ll find it’s equivalent to doing $a.Split(' ') which doesn’t help. Instead there’s a second overload that lets you specify a single argument, to the right of the operator, and this will split the string by whitespace and automatically remove empty entries: -split $a.
Code: PS> $a = 'ABC 69278 DEF 10278' PS> $a.Split(' ') ABC 69278 DEF 10278 PS> $a.Split(' ', [System.StringSplitOptions]::RemoveEmptyEntries) ABC 69278 DEF 10278 PS> -split $a ABC 69278 DEF 10278 PS> (-split $a)[2] DEF PS>[/quote]
Btw, are you going to get back to your previous thread?

 

I saw your reply, but forgot to mark as solved. Instead of escaping everything as admin, I wrote a simple batch script which can be executed as admin. I'm used to the Linux way, but I need to learn the right and wrong way to do things in Windows. I appreciate everyone's help!

 

Windows is a very different beast to tame than Linux.

If you’re more comfortable with it you can run bash shell scripts on Windows you know.

But good on you for wanting to picking up the new skills.