^\s*(\w+)\s*\(\s*(\d+)\D+(\d+)\D+\)\s*$

should work. After the match, backreference 1 will contain the month, backreference 2 will contain the first number and backreference 3 the second number.

Explanation:

^     # start of string
\s*   # optional whitespace
(\w+) # one or more alphanumeric characters, capture the match
\s*   # optional whitespace
\(    # a (
\s*   # optional whitespace
(\d+) # a number, capture the match
\D+   # one or more non-digits
(\d+) # a number, capture the match
\D+   # one or more non-digits
\)    # a )
\s*   # optional whitespace
$     # end of string

You said you are struggeling, what have you tried so far?

Please share your code so we can help.

You can use the ‘-match’ operator and then look for numbers in the string.

If you post code, please use the insert code button! Please and thank you!

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

If this is for SQL-Server, you can create a function e.g.

CREATE FUNCTION dbo.udf_GetNumeric  
(  
  @strAlphaNumeric VARCHAR(256)  
)  
RETURNS VARCHAR(256)  
AS  
BEGIN  
  DECLARE @intAlpha INT  
  SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric)  
  BEGIN  
    WHILE @intAlpha > 0  
    BEGIN  
      SET @strAlphaNumeric = STUFF(@strAlphaNumeric, @intAlpha, 1, '' )  
      SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric )  
    END  
  END  
  RETURN ISNULL(@strAlphaNumeric,0)  
END  
GO  

To create the function, create a new query, add the code above and execute it. Best done in SSMS (SQL-Server Management Studio)

And here I use it on a column that has alphanumeric values. ShipAddress is the original and ShipAddressNumbersOnly uses the function.