Replace string value in a file with filename

Question

0.00/5 (No votes)

See more:

i want to replace the string in a file with file name. I am having 3000 files with different file names. Is there any way i can do with batch script I am completely new to scripting. please help me on this

eg: I am having a file name as 12345678.txt inside the file I am having some records along with a string 99999999. now i want to replace 99999999 with the file name 12345678.

I am having files in C:\DATA\

What I have tried:

I am completely new to scripting. please help me

Posted 30-Aug-18 3:56am

suniti dinesh

Updated 30-Aug-18 6:22am

v2

Add a Solution

Comments

CHill60 30-Aug-18 10:37am

If it was a one-off I would probably use Notepad++ to do that for me rather than writing a script

suniti dinesh 30-Aug-18 10:57am

Hi Chill. Thank you. I am having 3000 files and every file has different file names(1000001.txt, 1000002.txt....1003000.txt). how can i replace the data(99999999) in every file with the file number in notepad++. if we can do it please guide me how to do it.

RedDk 30-Aug-18 14:47pm

Show your batch file code ... so far.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2018-08-30T06:23:00

Solution 1

Using PowerShell:

PowerShell

$files = Get-ChildItem -path C:\Data\ -filter *.txt
foreach ($file in $files)
{
    $content = Get-Content $file
    if ($content -match "99999999")
    {
        $content = $content -replace "99999999", $file.BaseName
        Set-Content $file $content
    }
}

Posted 30-Aug-18 6:23am

Richard Deeming

Comments

suniti dinesh 30-Aug-18 15:11pm

Hi richard thank you so much for your response. when i try to run powershell script. I am getting the below error
Get-Content : Cannot find path 'C:\Windows\system32\70002000.LDR' because it does not exist.
At C:\Script\Powershell.ps1:6 char:16
+ $content = Get-Content $file
+ ~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (C:\Windows\system32\70002000.LDR:String) [Get-Content], ItemN
otFoundException
+ FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.GetContentCommand

suniti dinesh 30-Aug-18 15:13pm

we are not mapping to the path where files are existing. we are mapping to system folder. please help me

Richard Deeming 30-Aug-18 15:18pm

I thought you were looking at files in C:\Data\?

If you're looking at files in C:\Windows\System32\, you'll need to make sure you're running PowerShell elevated.

Also, if you've changed the Get-ChildItem call to return hidden files by using the -Force parameter, you'll probably need to pass the -Force parameter to the Get-Content call as well.

suniti dinesh 30-Aug-18 15:33pm

Sorry for the confusion Richard. I have din't went to the path in powershell prompt. now i checked in the way you suggested. It worked like a champ. Thank you so much for you help

suniti dinesh 30-Aug-18 15:40pm

one more small doubt like after fetching the value 9999999 from the file and if i want to increment the value with 1 (eg: 10000000,10000001,10000001...till files in the folders end) and replace it with incremented value instead of copying file name and replacing.

Richard Deeming 30-Aug-18 15:44pm

$i = 10000000
foreach ($file in $files)
{
    $content = Get-Content $file
    if ($content -match "99999999")
    {
        $content = $content -replace "99999999", $i++
        Set-Content $file $content
    }
}

[no name] 3-May-21 4:40am

@Richard Deeming OK, I opened Windows Power shell as an admin, should I put all the code I found above at https://www.codeproject.com/Questions/1258369/Replace-string-value-in-a-file-with-filename with a space for each next line (and everything together)? I want to replace a string (or add matter just after the string) with the file name of each file for multiple files in a folder. Please answer.

[no name] 3-May-21 4:55am

@Richard Deeming I have described exactly what I want here: https://www.codeproject.com/Questions/5301551/How-to-add-the-file-name-of-each-file-in-a-folder
Please reply