Using regular expression with PowerShell [duplicate]

Question

I have a file with multiple expressions like $REGX('CareMedic.2_0','CustomerInformation','Customer Information'). The file can be an xml file, text file or any other type. If the file contains nine of those expressions, I'm trying to pull all nine.

I've written my code as below:

$input_path = ‘C:\Users\rparpani\Desktop\test2.xml’
$output_file = 'C:\Users\rparpani\Desktop\test2.text'
$regex = '\$REGX'
$output = select-string -Path $input_path -Pattern $regex -AllMatches | % { $_.Matches } | % { $_.Value } > $output_file

Write-Output($output)

Something seems to be wrong with my regex expression. Can someone please suggest the right way to achieve this?

I think you need to escape the $ (\$) in your regex otherwise it asserts the position at the end of the line — Itchydon
– Itchydon, Commented Mar 9, 2020 at 17:16
I tried doing that but it does not pull any values. If the file has 9 of the REGX expressions, I expect to pull them all. — caliGeek
– caliGeek, Commented Mar 9, 2020 at 17:30
If you run the code as far as -allmatches - what do you get? When I try your code it works for me. I have only tried with a txt file not with an xml — Itchydon
– Itchydon, Commented Mar 9, 2020 at 18:20
@Itchydon it writes to my txt file but it is just $RESX. I have to pull values between (). Once those values are extracted, I have to strip them apart and store it in 3 different columns — caliGeek
– caliGeek, Commented Mar 9, 2020 at 18:40

Mathias R. Jessen · Accepted Answer · 2020-03-09 17:34:24Z

0

$ is a metacharacter in regex, meaning "end of string", so if you're looking for the literal string $RESX, you need to escape $:

$regex = '\$REGX'

You can also have it escaped automatically:

$regex = [regex]::Escape('$REGX')

edited Mar 9, 2020 at 17:34

answered Mar 9, 2020 at 17:16

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

3 Comments

caliGeek Over a year ago

I tried changing that but it does not appear to pull any values

Mathias R. Jessen Over a year ago

In the example in your post it says "$REGX", but in the code you use "$RESX", typo perhaps?

caliGeek Over a year ago

It was a typo. I corrected it

Collectives™ on Stack Overflow

Using regular expression with PowerShell [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related