Powershell delete text in string that does not match conditions

Question

I have a text file that I need to go through line by line and delete any text that is in quotation marks and does not match one of the following values:

192.168.10.1
192.168.11.1
192.168.12.1
192.168.13.1

My initial file would look something like this:

IPADDRESS "192.168.10.1" "192.168.11.1" "192.168.12.1" "192.168.13.1" "10.0.0.1"
IPADDRESS "192.168.10.1" "192.168.11.1" "127.0.0.1" "192.168.12.1" "192.168.13.1"

and I would like my output to be similar to the following:

IPADDRESS "192.168.10.1" "192.168.11.1" "192.168.12.1" "192.168.13.1"
IPADDRESS "192.168.10.1" "192.168.11.1" "192.168.12.1" "192.168.13.1"

I've experimented with using the -replace option, regular expressions, using the trim option, using a filter, using the -match option, to varying degrees of success, but I keep hitting a brick wall...

Shay Levy · Accepted Answer · 2012-11-27 10:00:18Z

2

You can split the line, remove unwanted parts with a regex pattern and assemble back the line:

Get-Content ip.txt | Where-Object {$_} | Foreach-Object {
   $line=$_.Split()
   $line[0] + ' ' + ($line -match '"192\.168\.1[0-3]\.1"') -join ' '
}

edited Nov 27, 2012 at 10:00

answered Nov 26, 2012 at 18:48

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

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

4 Comments

Stereostar Over a year ago

thanks for your assistance, unfortunately I'm getting the following error when trying that code: Method invocation failed because [System.String[]] doesn't contain a method named 'Split'. Am I missing something? Also, is there anyway of combining the regex matches to search for all the four values at once? Thanks

Stereostar Over a year ago

Thanks for the edited version @shay, that's put me in the right direction for what I need. Thanks

Shay Levy Over a year ago

Do you have blank lines in the file? I added a filter to ignore them. Give it a try. The regex pattern takes care of the ip range you specified.

Stereostar Over a year ago

No blank spaces, however I modified the regex to suit my exact needs, and with the help of your code it's working perfectly. I wouldn't have had a clue where to start with the split and join etc. Thanks a lot for your help

Collectives™ on Stack Overflow

Powershell delete text in string that does not match conditions

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related