Using regular expression with PowerShell

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, Mar 09 '20 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. — Raj Parpani, Mar 09 '20 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, Mar 09 '20 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 — Raj Parpani, Mar 09 '20 at 18:40
How about if you run up to -allmatches only - do you get the correct values? — Itchydon, Mar 09 '20 at 18:43
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/209333/discussion-between-raj-parpani-and-itchydon). — Raj Parpani, Mar 09 '20 at 18:45

Mathias R. Jessen · Accepted Answer · 2020-03-09T17:34:24.833

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 09 '20 at 17:34

answered Mar 09 '20 at 17:16

Mathias R. Jessen

135,435
9
130
184

I tried changing that but it does not appear to pull any values – Raj Parpani Mar 09 '20 at 17:28
In the example in your post it says "$RE**G**X", but in the code you use "$RE**S**X", typo perhaps? – Mathias R. Jessen Mar 09 '20 at 17:32
It was a typo. I corrected it – Raj Parpani Mar 09 '20 at 17:33

Using regular expression with PowerShell

1 Answers1