Example 3 and 4 for https://powershell.org/forums/topic/sort-csv-data/

powershellorg-forum-topic-sort-csv-data.ps1

$csvFileName = 'C:\My\Input.csv'

# Example 3 - Using the -match operator with a more complex regular expression to extract the IP address
Import-Csv -Path $csvFileName | 
    ForEach-Object {
        if ($PSItem.URL -match '(?<IPAddress>[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3})') {
            $Matches.IPAddress
        }
    }

# Example 4 - Using the -match operator with a more regular expression to extract the IP address
#             and casting to IPAddress to ensure we get a valid IP address
Import-Csv -Path $csvFileName | 
    ForEach-Object {
        if ($PSItem.URL -match '(?<IPAddress>[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3})') {
            ([IPAddress] $Matches.IPAddress).IPAddressToString
        }
    }