# Commands

[`awk`](https://likegeeks.com/awk-command/) : manage log files into readable reports with [examples](https://www.geeksforgeeks.org/awk-command-unixlinux-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<br>

Get-Command \[NAME-EXECUTABLE-FILE] | Select-Object \*\
Use to find filelocation of executable

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

get baseboard information from powershell

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

prefix "Prefix\_" to all files in a directory&#x20;

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