Batch Script - Extract EVERYTHING after the LAST Back Slash in a File

I am sure that I am overthinking this as far as putting a Script together.

I have a Script that extracts EVERYTHING from a Folder [ ALL Folders & Sub-Folder Names, ALL Filenames within them including the Suffix and Size ] and creates a .log file. The .log file includes the FULL Path name. So far so good.

I have a .log file with Entries: 87,434.

Obviously, with such a big file, there are different amounts of \ [ Back Slashes ] within the Path name. How can I extract just the data AFTER the LAST \ please ?

Here is a small example . . .

Code:

G:\300GB_From_Internal_HDD\Kingston - Old Stick\KINGSTON\Tiny Hard Disk Backup\Favorites\Current Project\z1.url [Size: 260 Bytes]
G:\300GB_From_Internal_HDD\Paul Black - FULL Backup 29-Oct-2018\Documents\Paul Black - Personal\eBay\Bought.docx [Size: 210777 Bytes]
G:\300GB_From_Internal_HDD\Paul Black - FULL Backup 29-Oct-2018\Documents\Paul Black - Personal\eBay\Tables.docx [Size: 180517 Bytes]
G:\300GB_From_Internal_HDD\System Image-Backups\System Image-Backup Created 23-May-2017\Favorites\Music - YouTube\Steve Roach & Others\Dream Circle Cobalt Sun & Steve Roach - YouTube.url [Size: 355 Bytes]
G:\300GB_From_Internal_HDD\[00] Paul Black - FULL Backup 31-May-2019\Documents\Paul Black - Movies\Super Mario Bros\vlcsnap-2016-12-16-12h58m45s697.png [Size: 50385 Bytes]
G:\300GB_From_Internal_HDD\[00] Paul Black - FULL Backup 31-May-2019\Documents\Paul Black - Personal\Miscellaneous\Master - House Specifications.xlsm [Size: 17555 Bytes]
G:\300GB_From_Internal_HDD\[00] Paul Black - FULL Backup 31-May-2019\Documents\Paul Black - Personal\Miscellaneous\Master - Shopping List.xlsm [Size: 14567 Bytes]
G:\300GB_From_Internal_HDD\[00] Paul Black - FULL Backup 31-May-2019\Documents\Paul Black - Personal\Miscellaneous\Videos.txt [Size: 458 Bytes]
G:\300GB_From_Internal_HDD\[00] Paul Black - FULL Backup 31-May-2019\Favorites\General\List.log file.url [Size: 713 Bytes]
G:\300GB_From_Internal_HDD\Kingston - 32 GB - Red USB\Photos\Sally\Sally 2.jpg [Size: 76108 Bytes]

I have tried to do this in OpenOffice, but to NO avail.

Thanks in advance.

BRILLIANT @das10. Thanks, I can work with that.

You're welcome.

pn: just testing using bat/powershell.
BAT file to do same search/replace:

Code:

<# ::
setlocal
powershell -noprofile -ExecutionPolicy ByPass "[ScriptBlock]::Create((${%~f0} | out-string)) | Invoke-Expression" & Exit
goto :EOF
#>
############################     powershell block    ############################    
$OurFile = Get-Content -Path 'C:\custom\input.txt' -Raw     # adding -Raw reduces processing time considerably.
foreach ($line in $OurFile) {
$line -replace '.*\\','' | Out-File 'C:\custom\output.txt' -Append -Encoding Ascii
} 
exit

Thanks @das10,

das10 said:

pn: just testing using bat/powershell.
BAT file to do same search/replace:

Code:

<# ::
setlocal
powershell -noprofile -ExecutionPolicy ByPass "[ScriptBlock]::Create((${%~f0} | out-string)) | Invoke-Expression" & Exit
goto :EOF
#>
############################     powershell block    ############################    
$OurFile = Get-Content -Path 'C:\custom\input.txt' -Raw     # adding -Raw reduces processing time considerably.
foreach ($line in $OurFile) {
$line -replace '.*\\','' | Out-File 'C:\custom\output.txt' -Append -Encoding Ascii
} 
exit

WOW, that runs quick and produces the required output.

Just one question. I have a header that I want to keep, so the data actually starts at Line 6. Is there anyway to include that in the Script please ?

Thanks.

Thanks @ricardobohner,

ricardobohner said:

If you drag & drop a text file like in the example to this batch file it should save what you want in a file called result:

Code:

@echo off
for /f "usebackq delims=" %%a in ("%~1") do echo %%~nxa>>result.txt

That does indeed output the correct results, but it took about 15 minutes to process 87,434 lines.

Thanks @das10,

---

das10 said:

Code:

Get-Content $List_IN | Select -First 1  | Out-File $List_OUT -Encoding Ascii

I changed the above line to . . .

Code:

Get-Content $List_IN | Select -First 5 | Out-File $List_OUT -Encoding Ascii

---

das10 said:

Code:

$List_IN  = 'C:\custom\input.txt'
$List_OUT = 'C:\custom\output.txt'

I changed the above lines so as to use the 'Master Script' Variables to . . .

Code:

$List_IN  = $Env:OFN
$List_OUT = $Env:RED

---

I also added the line . . .

Code:

if (Test-Path $List_OUT) {Remove-Item $List_OUT}

. . . and it works perfectly.

---

The extra time taken for 87,434 lines is ONLY about 5 Seconds longer [ 16 Seconds as oppsed to 11 Seconds ]. I can certainly live with that.

I have set it up so I just Call the Script from my 'Master Script'.

Thanks again.