Get-EmailFromODFBUrl.ps1

$personalSites = @"
personalSite
/personal/a_v_d_hoogt_simba_nl/
/personal/h_altafah_simba_nl/
/personal/c_v_d_meulen_simba_nl/
/personal/stand_simba_nl/
/personal/floortje_janssen_simba_nl/
/personal/j_dubendorffer_sudoku_nl/
/personal/m_d_haas_sudoku_nl/
/personal/j_slimmer_sudoku_nl/
/personal/m_rijs_sudoku_nl/
/personal/b_janssen_despacito_com/
/personal/m_pools_despacito_com/
/personal/r_stewardess_despacito_com/
/personal/t_koestsier_despacito_com/
"@ | ConvertFrom-Csv

$personalSites |
    ForEach-Object {
    #Get ODFB part
    Try {
        $arrODFBUrl = ($($_.personalSite).Split('//'))[-2].Split('_')

        $count = @($arrODFBUrl).Count
        $index = 1
        $emailUsedForODFB = $arrODFBUrl[0]
        Do {

            if ($arrODFBUrl[$index] -like 'despacito*') {
                $emailUsedForODFB = "$($emailUsedForODFB)@$($arrODFBUrl[$index])"
            }
            elseif ($arrODFBUrl[$index] -like 'simba*') {
                $emailUsedForODFB = "$($emailUsedForODFB)@$($arrODFBUrl[$index])"
            }
            elseif ($arrODFBUrl[$index] -like 'sudoku*') {
                $emailUsedForODFB = "$($emailUsedForODFB)@$($arrODFBUrl[$index])"
            }
            else {
                $emailUsedForODFB = "$($emailUsedForODFB).$($arrODFBUrl[$index])"            
            }
            $index++  
        }until($index -eq $count)
        
        #Some ODFB may have a '1' at the end. Just remove that
        if ($emailUsedForODFB -like '*nl1') {
            $emailUsedForODFB = $emailUsedForODFB -replace ".$"
        }

        $samAccountName = $emailUsedForODFB.Split('@')[0].ToLower()
        $targetEmail    = '{0}@urv.onmicrosoft.com' -f $samAccountName

        [PSCustomObject]@{
            SamAccountName     = $samAccountName
            SourceEmail        = $emailUsedForODFB
            SourcePersonalUrl  = $($_.personalSite)
            SourceGeneratedUrl = 'https://irwins-my.sharepoint.com/personal/{0}/' -f $emailUsedForODFB.Replace('@', '_').Replace('.','_').ToLower()        
            TargetEmail        = $targetEmail
            TargetGeneratedUrl = 'https://urv-my.sharepoint.com/personal/{0}/' -f $targetEmail.Replace('@', '_').Replace('.','_').ToLower()        
        }
    }
    catch {
        Write-Warning 'Not a valid personal site format'
    }
} | 
Out-GridView