Montag, 5. Dezember 2011

Powershell CSV Import und Ausgabe konvertieren

Importieren:
$fc = import-csv Input.txt  -delimiter ";" -header  "Knr","Anrede","Vorname","Nachname","Straße","PLZ","Stadt","Land"

Konvertieren und schreiben:
$fc | foreach {$_.Anrede+";"+$_.Nachname+";"+$_.Vorname+";"+$_.Straße+";"+$_.Land+
";"+$_.PLZ+";"+$_.Stadt} > Output.txt

Quicksort mit Linq

public void Sort(IEnumerable input, List acc)
{
    if (input.Count() <= 1) 

     { acc.AddRange(input); 
       return; 
     } 
     Sort(input.Where(n => n < input.First()), acc); 
     acc.AddRange(input.Where(n => n == input.First()));
     Sort(input.Where(n => n > input.First()), acc);
}

Mittwoch, 30. November 2011

Rename files with Power Shell

Remove extension:
gci *.deploy |%{rename-item $_.fullname -newname $_.basename}


Rename replace with expression:
gci *.jpg | rename-item -newname {$_.name -replace '^','ico_'}


Check results with whatif:
gci *.deploy |%{rename-item $_.fullname -newname $_.basename -whatif}
gci *.jpg | rename-item -newname {$_.name -replace '^','ico_'} -whatif

Source