Powershell script to read all files in folders and replace a text

Question

I've few folders and nested sub-folders. I would like to filter all the files in the folder including the sub folders and list files with extension .XSD and search for the text called NewDataSet and replace the text with the name of the File.

I would like to perform this using Windows Powershell (ps1) script. Please help me out.

jdweng · Accepted Answer · 2022-10-11 12:24:20Z

1

Try following :

using assembly System
using assembly System.IO

$folder = "c:\temp"

$schemas = [System.IO.Directory]::GetFiles("$folder", "*.XSD")

foreach($schema in $schemas)
{
   $text = [System.IO.File]::ReadAllText($schema)
   $text = $text.Replace("NewDataSet", $schema)
   [System.IO.File]::WriteAllText($schema, $text)
 
}

answered Oct 11, 2022 at 12:24

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

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

2 Comments

qbso-nr Over a year ago

The entire file path is being replaced. Instead, I've slightly modified your script to suit the requirement. using assembly System using assembly System.IO $folder = "D:\Test db\Forms\Test" $schemas = [System.IO.Directory]::GetFiles("$folder", "*.XSD") foreach($schema in $schemas) { $fileName = [System.IO.Path]::GetFileNameWithoutExtension($schema) $text = [System.IO.File]::ReadAllText($schema) $text = $text.Replace("NewDataSet", $fileName+"DS") [System.IO.File]::WriteAllText($schema, $text) }

jdweng Over a year ago

I suspected that was going to happen. I wasn't sure if you needed the full pathname or just the base name of the file. I figured you would need to make some modification of the code.

Collectives™ on Stack Overflow

Powershell script to read all files in folders and replace a text

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related