powershell, substring. replace absolute urls with relative urls

Question

I have a top navigation bar which was built using absolute urls, instead of relative urls, the problem is, if I do backup restore of that site collection from PROD to QA, then the urls in QA point to production.

So, I am trying to create a script to replace absolute urls, with relative Urls.

The specific question would be:. With the know Url Root, and a lot of urls, how can I remove the first from the second?

Example: If I have www.mydomain.com in a variable. And then in a second variable I have www.mydomain.com/sites/site1 I want it to return only /sites/site1

This is what I got so far

 $var1 = "https://xxxx.com"
$var2 = "https://xxxxx.com/sites/10024960/"
$rootSiteCollection = Get-SPSite $siteCollectionUrl
if ($rootSiteCollection -ne $null)
{
     if($Site.RootWeb.AllProperties["WebTemplate"] -eq "Client")
     {
        $rootWeb = $rootSiteCollection.RootWeb
        $navigationNodes = $rootWeb.Navigation.TopNavigationBar 
        if ($navigationNodes -ne $null)
        {
            foreach($navNode in $navigationNodes)
            {
                write-host 'Old Url: '  $navNode.Url

                $regex = "^$([regex]::Escape($var1))(.+)"
                $var2 -replace $regex,'$1'

                write-host 'New Url: '  $var2

                #if($navNode.Children.Count -ge 0)
                #{
                #    foreach($navNodeChild in $navNode.Children)
                #    {
                #        write-host 'Old Url'
                #        write-host $navNode.Url
                #    }
                #}
            }
        }
    }
}

On the screenshot below the old url is:

https://xxx.com/Pages/clientinvoices.aspx

The new Url should be:

/Pages/clientinvoices.aspx

http://screencast.com/t/73Uof4je

You have 4 x's in the url in Var1, and 5 in the one in Var2, so it's not going to match. — mjolinor
– mjolinor, Commented Oct 28, 2013 at 14:16

jdphenix · Accepted Answer · 2014-03-21 05:26:13Z

2

Something like this?

$$var1 = 'https://example.com'
$var2 = 'https://example.com/Pages/clientinvoices.aspx'

$regex = "$([regex]::Escape($var1))(.+)"
$var2 = $var2 -replace $regex,'$1'

$var2

/Pages/clientinvoices.aspx

edited Mar 21, 2014 at 5:26

jdphenix

15.5k5 gold badges46 silver badges74 bronze badges

answered Oct 28, 2013 at 14:00

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

3 Comments

mjolinor Over a year ago

The code just ouputs the trimmed string. I changed the code to assign the result back to var2, to match your usage.

Luis Valencia Over a year ago

please check at my updated question with an screenshot, maybe I was not clear enough?

mjolinor Over a year ago

I updated the script to match your example, and it appears to do what you're asking for.

Collectives™ on Stack Overflow

powershell, substring. replace absolute urls with relative urls

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related