Hi. I’m trying to extract substrings and values from a table. I need to extract the Size, Used and Avail figures so that I end up with the following: Raw: 292.2 Size: 286.4 Used: 66.8 PctUsed: 23 Avail: 219.6 PctAvail 77 I’ve gotten this far: $tbl = "Cluster Name: Isilon01", "Cluster Health: …

If split worked once why not continuing? :wink: ForEach ($t in $tbl) { If ($t -match '^Size') { $OutObj = "" | Select-Object -Property Size, Used, Avail $OutObj.Size = (($t -split ':').trim() -split 'T')[1] } ElseIf ($t -match '^Used') { $OutObj.Used = (($t -sp…

This will also give you the percentages. Olaf’s approach is probably better but this one worked for me as well. $tbl = "Cluster Name: Isilon01", "Cluster Health: [ ATTN]", "Cluster Storage: HDD SSD Storage", "Size: 286.4T (292.2T Raw) 0 (0 Raw)", "VHS Size…

[image] ferc: probably better “better” depends on the point of view. If the result fits who cares about the way? :wink:

Agree with you @Olaf . In fact, I did not notice there were two strings that match ‘Size’. Adding the ^ anchor to specify the beginning of the line was clever. I missed that one.

Olaf, Ferc, Double splits is something that for whatever reason did not occur to me. I guess I thought it would throw a syntax error. When I saw your answer, a big light bulb went on in my head :smiley: I borrowed from both of your suggestions and now have the following working code: Function Get…

[image] palmero: Olaf, what is the caret (^) character at the start of each -match string (i.e. ‘^Size’, etc.)? Did you try to search for it? :wink: Regex Tutorial - Start and End of String or Line Anchors In a regular expression, the caret matches the concept “start of string”,…

Glad you got it solved. I just wanted to add a few more ways to solve it. Each of these uses a switch statement to read the variable line by line. Another benefit of switch statement is being able to read a file directly. The result of each of these is setting the five variables with the correct va…

Hi Olaf, I did several web searches for the ^ anchor, but didn’t get any clear hits. I always try to find a resolution before asking. Also, I was already here, and thanks to you I now have an answer and a new web link for future questions. Thanks again. The input comes from a CLI plink command us…

[image] palmero: I did several web searches for the ^ anchor, but didn’t get any clear hits. I added a link to my answer. You have seen this, didn’t you? :wink: If you missed it … there are a lot of specialized sites on the internet offering information about regex.One of them is: …

Splitting strings

PowerShell Help

Olaf March 14, 2021, 6:00pm 10

I added a link to my answer. You have seen this, didn’t you? If you missed it … there are a lot of specialized sites on the internet offering information about regex.One of them is:

Another one where you can test your regex patterns is

Have a lot of fun!

Topic		Replies	Views
Some Idea of substrings PowerShell Help	16	279	May 28, 2018
Need help working with .XML files PowerShell Help	8	5350	March 17, 2021
Building objects from Text log PowerShell Help	13	305	May 22, 2016
Extracting Data from Text File PowerShell Help	12	1560	April 4, 2017
Extract a word we don't know of a chain file ? PowerShell Help	10	341	March 14, 2019

Splitting strings

Related topics