extract a word after an IP address if given string is match

Question

trying to get Regex pattern to extract host name from an issue description line. tried with lot of pattern but unable to get it.

tried with pattern but dont know how to get server name.

CPU monitor on .*\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\s-\s

issue text:
INFRA : Memory monitor on 172.16.0.1 - SERVER1 78% avg
INFRA : CPU monitor on 172.16.0.2 - SERVER2 100% used
INFRA : Disk space on 172.16.0.3 - SERVER3

condition: if "CPU monitor on" contains then extract SERVER2
expected output: SERVER2

Any help will be highly appreciated!!!

Answer 1

I'm not real good with regex, but I enjoy a challenge. I got this Powershell code to work.

$src = @("INFRA : Memory monitor on 172.16.0.1 - SERVER1 78% avg",
         "INFRA : CPU monitor on 172.16.0.2 - SERVER2 100% used",
         "INFRA : Disk space on 172.16.0.3 - SERVER3"
)

foreach ($line in $src) {
    if ($line -match '(?:(CPU monitor on).*(?:- ))(.*?(?=\s))') {
        "I found this line......: {0}" -f $line
        "And this server name...: {0}" -f $matches[2] 
        $matches
    }
} 

Answer 2

Hi,

Based on my understanding, regular expression is used to match a string. To extract the string, we may need other functions.

Acoording to the expression above, it matches.

If we want to extract a portion of a string, we may refer to the following article.
https://stats.idre.ucla.edu/stata/faq/how-can-i-extract-a-portion-of-a-string-variable-using-regular-expressions/
Note: this is not from MS, just for your reference.

Hope the above information helps.

Alex Zhu

---

If the response is helpful, please click "Accept Answer" and upvote it.