Utilizing Powershell to eliminate characters from a string

Question

Utilizing Powershell to eliminate characters from a string

After pulling a list of IPs from a JSON file, I've been using the code snippet below:

$Request = 'https://url-to-json.com/file.json'
$AWSIPs = Invoke-WebRequest $Request | ConvertFrom-Json | Select-Object prefix -ExpandProperty prefixes -ExcludeProperty ("/.*") | Where-Object -Property "service" -EQ "service_name" | select ip_prefix
foreach ($awsip in $AWSIPs){
echo $awsip
}

The IPs are displayed as follows: - 0.0.0.0/00

0.0.0.0/00
0.0.0.0/00
0.0.0.0/00
0.0.0.0/00
0.0.0.0/00

However, I now need to strip out the "/00" at the end before proceeding with using these IPs.

I would be grateful for any assistance in achieving this task.

Many thanks.

json windows powershell scripting

Answer 1

Answer №1

Here is a solution using the -replace method:

$ips =  '192.168.1.1/24',
        '10.0.0.1/16',
        '172.16.0.1/12'

$ips -replace '(.*)/.*', '$1'

You can see that you can apply the -replace directly to an array in PowerShell.

The result will be:

192.168.1.1
10.0.0.1
172.16.0.1

Another option is to use -split, but it requires an explicit loop:

foreach ($ip in $ips) {
  ($ip -split '/')[0]
}

Although it's possible to avoid the loop, it's not recommended for performance and readability reasons. Here is an example that utilizes PowerShell's flexibility:

($ips -split '/')[(0..($ips.Count-1)).ForEach({ $_ * 2 })]

Answer 2

Here is a solution using the -replace method:

$ips =  '192.168.1.1/24',
        '10.0.0.1/16',
        '172.16.0.1/12'

$ips -replace '(.*)/.*', '$1'

You can see that you can apply the -replace directly to an array in PowerShell.

The result will be:

192.168.1.1
10.0.0.1
172.16.0.1

Another option is to use -split, but it requires an explicit loop:

foreach ($ip in $ips) {
  ($ip -split '/')[0]
}

Although it's possible to avoid the loop, it's not recommended for performance and readability reasons. Here is an example that utilizes PowerShell's flexibility:

($ips -split '/')[(0..($ips.Count-1)).ForEach({ $_ * 2 })]

Utilizing Powershell to eliminate characters from a string

Answer №1

Similar questions

What is the best way to modify a JSON file using PowerShell?

Understanding and aggregating data from JSON files

Turning PHP array into JSON using Zend RPC

Inaccurate formatting of body in Swift POST request received by node.js/express application

While going through multiple JSON links, I encountered a JSON decode error

AngularJS - Choose and establish initial values for Editing or Creating New Items

Navigating through JSON arrays with Node.js

What is the best way to retrieve all objects from this data model?

Inquiries regarding the recently updated Instagram API for integration with Swift 3. Exploring features such as location coordinates (latitude and longitude) and hashtag

The WCF response has been deemed invalid because of the presence of an unexpected string combination involving WCF and JSON

Tips for effectively redirecting traffic to another website

Getting all the dictionary data from a JSON file by searching for a specific value

Storing the result of parsing JSON data into a global variable

Storing JSON data for retrieval using Ajax request

Navigating JSON Data with ES6 Iteration

Learn how to effortlessly update models by integrating AngularJS with Django and Django Rest Framework

Arranging JSON data in Python based on string values for sorting

Encountered an issue while setting up the MongoDB dependencies for the Node.js application

Unable to view text in TableView when fetching JSON data from API request

Generating an image from a byte array using Jax-RS