Wsrtjtyk

I am sort of new to scripting and here's my task:

A folder with X files. Each file contains some Word documents, Excel sheets, etc. In these files, there is a client name and I need to assign an ID number.

This change will affect all the files in this folder that contain this client's name.

How can do this using Windows Power Shell?

$configFiles = Get-ChildItem . *.config -rec

 foreach ($file in $configFiles)

{

(Get-Content $file.PSPath) |

Foreach-Object { $_ -replace " JOHN ", "123" } |

Set-Content $file.PSPath

}   

Is this the right approach ?

As @lee_Daily pointed out you would need to have different code to perform a find and replace in different file types. Here is an example of how you could go about doing that:

$objWord = New-Object -comobject Word.Application  

$objWord.Visible = $false



foreach ( $file in (Get-ChildItem . -r ) ) {

    Switch ( $file.Extension ) {

        ".config" {

            (Get-Content $file.FullName) |

                Foreach-Object { $_ -replace " JOHN ", "123" } |

                    Set-Content $file.FullName

        }

        {('.doc') -or ('.docx')} {

            ### Replace in word document using $file.fullname as the target

        }

        {'.xlsx'} {

            ### Replace in spreadsheet using $file.fullname as the target

        }

    }

}

For the actual code to perform the find and replace, i would suggest com objects for both.

Example of word find and replace https://codereview.stackexchange.com/questions/174455/powershell-script-to-find-and-replace-in-word-document-including-header-footer

Example of excel find and replace Search & Replace in Excel without looping?

I would suggest learning the ImportExcel module too, it is a great tool which i use a lot.

For Word Document : This is what I'm using. Just can't figure out how this script could also change Header and Footer in a Word Document

$objWord = New-Object -comobject Word.Application  

$objWord.Visible = $false



$list = Get-ChildItem "C:Users*.*" -Include *.doc*  

foreach($item in $list){

$objDoc = $objWord.Documents.Open($item.FullName,$true)



$objSelection = $objWord.Selection 

$wdFindContinue = 1

$FindText = " BLAH " 

$MatchCase = $False 

$MatchWholeWord = $true

$MatchWildcards = $False 

$MatchSoundsLike = $False 

$MatchAllWordForms = $False 

$Forward = $True 

$Wrap = $wdFindContinue 

$Format = $False 

$wdReplaceNone = 0 

$ReplaceWith = "help " 

$wdFindContinue = 1 

$ReplaceAll = 2



$a = $objSelection.Find.Execute($FindText,$MatchCase,$MatchWholeWord, ` 

$MatchWildcards,$MatchSoundsLike,$MatchAllWordForms,$Forward,` 

$Wrap,$Format,$ReplaceWith,$ReplaceAll) 

$objDoc.Save()

$objDoc.Close()

}

$objWord.Quit()

What If I try to run on C# ? Is anything else missing?

 }

string rootfolder = @"C:Temp";

   string files = Directory.GetFiles(rootfolder, "*.*",SearchOption.AllDirectories);

   foreach (string file in files)

   {    try

     {    string contents = File.ReadAllText(file);

       contents = contents.Replace(@"Text to find", @"Replacement text");

       // Make files writable

   File.SetAttributes(file, FileAttributes.Normal);



   File.WriteAllText(file, contents);

 }

 catch (Exception ex)

 {    Console.WriteLine(ex.Message);

     }

   }