Shell – Remove all characters appearing before a certain string in PowerShell

powershellscript

I have a text file with the following information:

24.;128.32.;128,6;0.128.68.;128,1.;0.76.;;;;;0,1.;0.4.;0,2.;0.5.;0,4.;;;0.76.;128,;;;;;;;;172.30.1.1,172.30.1.228,

I need to remove all characters that appear before 172.30.1.1.
For my file, it looks like this:

172.16.1.1,172.16.1.210,

I'm using the Poweshell to do this, but without success.

Best Answer

A lot of it will depend on how consistent your data will be. There will be a multitude of methods. You could do it with a split:

$test = '24.;128.32.;128,6;0.128.68.;128,1.;0.76.;;;;;0,1.;0.4.;0,2.;0.5.;0,4.;;;0.76.;128,;;;;;;;;172.30.1.1,172.30.1.228,'
$partIWant = $test.Split(';')[$($test.Split(';').Count-1)]
$partIWant

You could use a regex as well:

$partIWant = $test -replace '.+(\d+.\d+\.\d+\.\d+\.\d+,\d+\.\d+\.\d+\.\d+,)', '$1'
$partIWant

You will need to pick the method that you want to use and craft it to the specific data that you will be working with.

Related Solutions

Shell – Replacing special characters in text file using PowerShell

Appleoddity's referenced article covers what I am looking for. Thanks! https://stackoverflow.com/questions/4126603/powershell-or-batch-find-and-replace-characters

Shell – find all files and lines that contains a specific string

It's critical that if you are new, that you first spend the time to ramp up to prevent a lot of unnecessary frustration and confusion you are going to encounter.

Do a search on Microsoft Virtual Academy on PowerShell and YouTube for no cost video training.

Here are some other resources and advice:

Free eBooks are available on this site
Read the full help file on any cmdlet you are trying to use
Practice with the examples
Read the helpfile again
Pick up a few good books, like, 'PowerShell in a Month of Lunches'.
There are lots of free PowerShell eBooks on Microsoft's websites and others.

See also: The PowerShell Survival Guide

As for a specific example on your question. How about this approach?

$searchWords = @('Hello','Client')

Foreach ($sw in $searchWords)
{
    Get-Childitem -Path "d:\temp" -Recurse -include "*.txt","*.csv" | 
    Select-String -Pattern "$sw" | 
    Select Path,LineNumber,@{n='SearchWord';e={$sw}}
}


# Partial Results

Path                                            LineNumber SearchWord
----                                            ---------- ----------
D:\temp\Duplicates\BeforeRename1\PsGet.txt             157 Hello     
D:\temp\Duplicates\BeforeRename1\PsGet.txt             161 Hello     
D:\temp\Duplicates\BeforeRename1\StringText.txt          1 Hello     
D:\temp\Duplicates\PoSH\PsGet.txt                      157 Hello     
D:\temp\Duplicates\PoSH\PsGet.txt                      161 Hello     
D:\temp\Duplicates\PoSH\StringText.txt                   1 Hello     
...    
D:\temp\Duplicates\BeforeRename1\PoSH-Get-Mo...        108 Client    
D:\temp\Duplicates\BeforeRename1\Powershell ...         12 Client    
D:\temp\Duplicates\BeforeRename1\Powershell ...         15 Client    
... 
D:\temp\Duplicates\BeforeRename1\WindowsFeat...         92 Client    
D:\temp\Duplicates\BeforeRename1\WindowsFeat...         94 Client    
D:\temp\Duplicates\BeforeRename1\WindowsFeat...        149 Client    
D:\temp\Duplicates\BeforeRename1\WindowsFeat...        157 Client    
D:\temp\Duplicates\BeforeRename1\WindowsFeat...        191 Client    
D:\temp\Duplicates\BeforeRename1\WindowsFeat...        239 Client    
D:\temp\Duplicates\BeforeRename1\WindowsFeat...        241 Client

Best Answer

Related Solutions

Shell – Replacing special characters in text file using PowerShell

Shell – find all files and lines that contains a specific string

Related Question