uweziegenhagen.de

# Finde alle Dateien im aktuellen Verzeichnis, die am Ende des Dateinamens acht Ziffern haben
ls |  % { if ($_.name -match "\d{8}\.\w{3}$") {
# Ersetze diesen Dateinamen  durch das Datum
rni $_.fullname $_.name.replace($_.name,$_.name.substring($_.name.length-12,8)
# verbunden mit dem Dateinamen ohne Datum
+ "_" + $_.name.substring(0,$_.name.length-13)
# und der Dateiendung.
+ $_.name.substring($_.name.length-4,4))
  }}

# Suche alle Dateien, die mit acht Ziffern anfangen
ls |  % { if ($_.name -match "^\d{8}.*") { 
# Benenne die Datei um, erst das Jahr, dann der Monat
# dann der Tag
rni $_.fullname ($_.name.substring(4,4) + $_.name.substring(3,2)
+ $_.name.substring(0,2) + "_" 
+ $_.name.replace($_.name,$_.name.substring(9,$_.name.length-9)))
}}

$excel = New-object -comobject Excel.Application
$excel.Visible = $true
$excel.DisplayAlerts = $false
$workbook = $excel.Workbooks.Add()
$sheet = $workbook.Worksheets.Item(1)
$sheet.Name = 'Hallo Welt'
 
foreach ($i in 1..25){
    $sheet.cells.item($i,1) = $i
    $sheet.cells.item($i,2) = $i*2
}
 
# Bar Chart
# Datenherkunft
$range = $sheet.range('a1:a25')
 
# Chart-Variable anlegen
$ch = $sheet.shapes.addChart().chart
# Typ zuweisen (Bar Chart)
$ch.chartType = 58
# Daten zuweisen
$ch.setSourceData($range)

foreach ($file in gci *.tex)
{
pdflatex $file.name 
}

dir /a
 
Get-ChildItem | Where-Object {$_.PSIsContainer
 
dir /a-
 
Get-ChildItem | Where-Object {!$_.PSIsContainer}
 
dir /o
 
Get-ChildItem | Sort-Object Date
 
dir /od /a-
 
Get-ChildItem | Where-Object {!$_.PSIsContainer} | Sort-Object Dat
 
dir /a
 
Get-ChildItem -force -path C:\ | Where-Object {$_.Mode -match "h"
 
dir /a-
 
Get-ChildItem -force -path C:\ | Where-Object {!$_.Mode -match "h"
 
dir /
 
Get-ChildItem | Select-Object Name

ls -recurse |  % {
if ($_.name -match "\d{8}_\d{8}.+") {
    $full  =  $_.fullname 
    $split =  $_.fullname.split("\") 
    $last  = $split[$split.length-1]
    $newpath = $split[0]
    foreach ($number in 1..($split.length-2) ) { $newpath += "\" + $split[$number] }
        $newpath += "\" + $last.substring(9,$last.length-9)
    }
    "mv"+ "`t" + $full + "`t" + $newpath
}

ls -recurse |  % {
if ($_.name -match "\d{8}_\d{8}.+") {
    rni $_.fullname $_.name.replace($_.name,$_.name.substring(9,$_.name.length-9))
}}

ls -recurse |  % {if ($_.name -match "\d{8}_\d{8}-.+") {$_.fullname}}

$excel = New-object -comobject Excel.Application
$excel.Visible = $false
$excel.DisplayAlerts = $false
$workbook = $excel.Workbooks.Add()
$sheet = $workbook.Worksheets.Item(1)
$sheet.Name = 'Hallo Welt'
$workbook.SaveAs('C:\hallowelt.xlsx')
$workbook.Close()
$excel.Quit()