Commands

awk : manage log files into readable reports with examples

sed: stream editor

Excel

=RIGHT(A1,LEN(A1)-SEARCH("#",SUBSTITUTE(A1,"","#",LEN(A1)-LEN(SUBSTITUTE(A1,"",""))))) to return string after last instance of \ character, useful for grabbing file names from absolute filepath

Power Shell

Remove first 8 characters in filename in folder get-childitem * | rename-item -newname { string .substring(8) } To narrow in on a specific file extension you would add the extension to the first *. Ex: get-childitem *.txt | rename-item -newname { string .substring(8) } to remove "Copy of " (8 characters) from sheet music

Get-WmiObject Win32_BaseBoard | Format-Table -Auto Manufacturer,Product,SerialNumber,Version

get baseboard information from powershell

$items=Get-ChildItem;
$items | Rename-Item -NewName { "Prefix_" + $_.Name };

prefix "Prefix_" to all files in a directory

from here https://community.spiceworks.com/how_to/149670-powershell-simple-file-rename-to-strip-beginning-characters