Replace Text within multiple Wikipages using PowerShell

  • Article

 Script for Sharepoint 2010 Enterprise Wikis!

$logfile = "c:\logfile.txt"
$web = Get-SPWeb "https://intranet/wikiurl"
$list = $web.GetList(($web.ServerRelativeUrl.TrimEnd("/") + "/Wiki%20Pages"))
 

$search = "search_text"
$replace = "replace_test"

(get-date).ToString() + " >>> Script Startet >> Parameter: Search = " + $search + " | Replace = "+$replace   | add-content $logfile
(get-date).ToString() + " >>> Script Startet >> Parameter: Search = " + $search + " | Replace = "+$replace   | add-content $logfile
foreach ($item in $list.items)
{
 

if ($item["Page Content"].contains($search))
{

$item.file.CheckOut();

(get-date).ToString() + " >>> " +  $item.name + " checked out"   | add-content $logfile

do {write-host -NoNewline .;Start-Sleep -m 10;} while ($item.file.CheckOutStatus -eq "None")

 
 

$item["Page Content"] = $item["Page Content"].replace($search ,$replace );

$item.update();

(get-date).ToString() + " >>> " +  $item.name + " modified"   | add-content $logfile

(get-date).ToString() + " >>> " +  $search + " changed by " + $replace  | add-content $logfile

sleep 1

$item.file.CheckIn("checked in by administrator");

(get-date).ToString() + " >>> " +  $item.name + " checked in"   | add-content $logfile

 
 

write-host $item.name "modified" -foregroundcolor red

}

}

 
 

_________________________________________________________________________________

Script for migrated SharePoint 2007 Wikis to SP 2010!

 
 

["Page Content"] has been replaced by ["ows_WikiField"]

 
 

 
 

 
 

$logfile = "c:\logfile.txt"

$web = Get-SPWeb "https://intranet/wikiurl"

$list = $web.GetList(($web.ServerRelativeUrl.TrimEnd("/") + "/Wiki%20Pages"))

 
 

$search = "search_text"

$replace = "replace_test"

 
 

 
 

(get-date).ToString() + " >>> Script Startet >> Parameter: Search = " + $search + " | Replace = "+$replace   | add-content $logfile

(get-date).ToString() + " >>> Script Startet >> Parameter: Search = " + $search + " | Replace = "+$replace   | add-content $logfile

foreach ($item in $list.items)

{

 
 

 if ($item["ows_WikiField"].contains($search))

 {

  $item.file.CheckOut();

  (get-date).ToString() + " >>> " +  $item.name + " checked out"   | add-content $logfile

  do {write-host -NoNewline .;Start-Sleep -m 10;} while ($item.file.CheckOutStatus -eq "None")

 
 

  $item["ows_WikiField"] = $item["ows_WikiField"].replace($search ,$replace );

  $item.update();

  (get-date).ToString() + " >>> " +  $item.name + " modified"   | add-content $logfile

  (get-date).ToString() + " >>> " +  $search + " changed by " + $replace  | add-content $logfile

  sleep 1

  $item.file.CheckIn("checked in by administrator");

  (get-date).ToString() + " >>> " +  $item.name + " checked in"   | add-content $logfile

 
 

  write-host $item.name "modified" -foregroundcolor red

 }

}

Comments

  • Anonymous
    January 01, 2003
    to run this script, you have to be a sharepoint farm admin.
    otherwhise you cannot run sharepoint specific powershell commands.

  • Anonymous
    January 01, 2003
    For other readers, if you just want to search and replace on a single page, edit the page in a non-Internet Explorer browser. Copy the text of the page to a text editor. Do the search and replace in the text editor. Then paste the updated text back in to the browser and save.

  • Anonymous
    June 05, 2013
    Nice post ,thanks for sharing this information . <a href="www.raybiztech.com/Sharepoint-Portal-Solutions.html">Sharepoint Developers</a>

  • Anonymous
    August 06, 2014
    Hi Thomas, script looks awesome but I'm having trouble referencing Get-SPWeb. Where can I get the PowerShell CmdLet Get-SPWeb? I'm not the SharePoint administrator, I just a user of our corporate SharePoint.

  • Anonymous
    January 28, 2015
    this is great to just change text on the page!
    What I really need, is to change the url of a link on a wiki page.

  • Anonymous
    March 18, 2015
    I was trying to update the links in SharePoint 2013 within the wiki pages changing it from /some/old/location/wikipage.aspx to just wikipage.aspx. Everything works until the Update. For some reason, item.Update() removes the href in a link after it runs.
    I really don't know why this happens and I've found nothing referencing that online.

  • Anonymous
    March 20, 2015
    The comment has been removed

  • Anonymous
    August 23, 2015
    The script looks good, but I keep getting below error ...


    You cannot call a method on a null-valued expression.
    At C:UsersSPSFarmAdminDesktopfindNReplace.ps1:25 char:7
    + if ($item["Page Content"].contains($search))
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

    You cannot call a method on a null-valued expression.
    At C:UsersSPSFarmAdminDesktopfindNReplace.ps1:25 char:7
    + if ($item["Page Content"].contains($search))
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

  • Anonymous
    November 12, 2015
    For SharePoint 2013 Enterprise WIki, use $item["Wiki Content"] instead of "Page Content". It works great! Thanks!

  • Anonymous
    September 07, 2017
    Ольга добрый день!Мне интересно цены на еду Если сам готовишь? И алкоголь на острове панглао