PlItems

ID: 278
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Prüfen ob Verzeichnis existiert
Link Credits: https://www.powershelladmin.com/wiki/Powershell_check_if_folder_exists
Code: $myFolder = "C:\TEMP" if ((Test-Path $myFolder) -eq $true) { write-host "Folder exists!" } else { write-host "Folder doesn't exist!" }

ID: 282
PlCodelang: PowerShell
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Link Credits: https://social.technet.microsoft.com/Forums/en-US/1ff6097b-0d6d-458c-bbef-529fa4e35238/powershell-format-a-date-after-using-adddays?forum=ITCG
Code: $d=(Get-Date).AddDays(-1) $output=Get-Date $d -format "yyyy-MM-dd" # 2014-02-27
Result Example:

2014-02-27

ID: 227
PlCodelang: PowerShell
PlGroup: Systeminfo
PlItemTitle: Hostnamen ermitteln
Code: $myHostname = [system.environment]::MachineName; write-host $myHostname; # prints MyComputer1 or srvWindows2

ID: 228
PlCodelang: PowerShell
PlGroup: Strings
PlItemTitle: Replace
Code: $str1 = "abc#def"; $str1 = $str1.Replace("#",";"); write-host $str1; # Output: abc;def

ID: 229
PlCodelang: PowerShell
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: # See also a good hint with explanation between like and contains: # http://windowsitpro.com/blog/powershell-contains $fullstring = "This is my string"; if ($fullstring -like "*my*") { Write-Host "found" -ForegroundColor Green; } else { Write-Host "nope" -ForegroundColor Red; }

ID: 234
PlCodelang: PowerShell
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: $myDate=Get-Date -format "yyyy-MM-dd hh:mm"; write-host $myDate -Foregroundcolor Cyan; # 2014-01-14 10:15 # Maybe AM or PM # For 24h Version $myDate=Get-Date -format "yyyy-MM-dd HH:mm"; write-host $myDate -Foregroundcolor Cyan; # 2014-01-14 22:15

ID: 248
PlCodelang: PowerShell
PlGroup: Fallunterscheidung
PlItemTitle: Ternary operator
Code: ## Example from here: https://www.kongsli.net/2012/02/23/powershell-another-alternative-to-ternary-operator/ $thisVar='OK' $resultVar = @{$true=1;$false=2}[$thisVar -eq 'OK'] // same as if-else construction if ($thisVar -eq 'OK') { $resultVar = 1; } else { $resultVar = 2; }

ID: 254
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Alle Dateien aus Verzeichnis auslesen
Code: $CSVFullPath = "C:\Temp" $FileFilter = "*.csv" $ListOfFiles = (Get-ChildItem -Path $CSVFullPath -Filter $FileFilter) | Select Name, BaseName, DirectoryName, FullName, Extension $ListOfFiles.Name
Result Example:

a.csv
b.csv
c.csv

ID: 255
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Verzeichnis rekursiv durchsuchen
Code: $CSVFullPath = "C:\Temp" $FileFilter = "*.*" $ListOfFiles = (Get-ChildItem -Path $CSVFullPath -Filter $FileFilter -Recurse) | Select Name, BaseName, DirectoryName, FullName, Extension | Where {$_.DirectoryName -like "*not_processed*" } $ListOfFiles.FullName
Result Example:

C:\Temp\ready_for_import_not_processed\a.csv
C:\Temp\ready_for_import_not_processed\b.csv

ID: 216
PlCodelang: ORACLE PL/SQL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: -- if todays date is: 2014-02-02 then a static query would be SELECT TO_DATE('02/02/2014','dd/mm/yyyy') FROM dual -- system variable SELECT SYSDATE AS TODAY FROM SYS."DUAL"

ID: 219
PlCodelang: ORACLE PL/SQL
PlGroup: Datenmengen
PlItemTitle: Anzahl Zeilen Resultset begrenzen
Code: SELECT * FROM ( SELECT * FROM tableA ) WHERE ROWNUM <= 100

ID: 247
PlCodelang: ORACLE PL/SQL
PlGroup: Datenbank
PlItemTitle: CSV erstellen
Code: SELECT FieldA, LISTAGG(CSVItem, ',') WITHIN GROUP (ORDER BY FieldA) AS Members FROM TableWithItems GROUP BY FieldA;

ID: 201
PlCodelang: Excel
PlGroup: Strings
PlItemTitle: Replace
Code: /* Cell A1 contains text "abc#def" */ =SUBSTITUTE(A1;"*";"/") /* Result will be: "abc/def" */

ID: 182
PlCodelang: Batch
PlGroup: Variablen
PlItemTitle: Deklaration einer Variable
Code: @echo off SET myVariable=This is my content SET myPathVariableWithBlanks="C:\Temp\Path With Blanks\File.txt" echo %myVariable% REM This is my content echo %myPathVariableWithBlanks% REM "C:\Temp\Path With Blanks\File.txt"

ID: 183
PlCodelang: Batch
PlGroup: Variablen
PlItemTitle: Wert einer Variable zuweisen
Code: @echo off cd C:\Temp REM Aktuelles Verzeichnis in einer Variable setzen SET mydir="Mein Verzeichnis lautet %CD%" echo %mydir% REM "Mein Verzeichnis lautet C:\Temp"

ID: 184
PlCodelang: Batch
PlGroup: Filehandling
PlItemTitle: Prüfen ob Datei existiert
Code: @echo off SET checkFileExists="C:\Temp\myFile.txt" IF exist %checkFileExists% GOTO :EXISTS GOTO :EXISTSNOT :EXISTS echo There it is :-) GOTO :END :EXISTSNOT echo Sorry, the file isn't there :-( GOTO :END :END echo End of program

ID: 198
PlCodelang: Batch
PlGroup: Konsolenverwaltung
PlItemTitle: Einlesen Konsoleneingabe
Code: @echo off SET mydir=%CD% set /p number=search this number?: echo %number% > "%mydir%\lastnumbersearched.txt" echo dir/b/s *%number%*.* echo. echo. dir/b/s *%number%*.* echo. echo. pause

ID: 149
PlCodelang: Perl
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: use POSIX qw/EXIT_SUCCESS EXIT_FAILURE/; # Datum Vorbereitung: my $DateTime = POSIX::strftime('%c', localtime(time)); my ($Date, $Time) = split(/\s+/, $DateTime); my ($Day, $Month, $Year) = split(/\./, $Date); my ($Hour, $Minute, $Second) = split(/:/, $Time ); my $Datum = "$Year"."$Month"."$Day"; #oder # my $Datum = "$Day"."$Month"."$Year"; my $Uhrzeit = "$Hour".":"."$Minute".":"."$Second";

ID: 142
PlCodelang: JavaScript
PlGroup: URL-Handling
PlItemTitle: Aktuelle URL bekommen
Code: // http://www.w3.org/TR/DOM-Level-2-HTML/html.html#ID-46183437 myURL = document.URL; // => http://myDNSNameOrIP:1234/path/testfile.html

ID: 143
PlCodelang: JavaScript
PlGroup: URL-Handling
PlItemTitle: Domain und Port einer URL
Code: domainAndPort = document.URL.split("/")[2]; // => 192.168.1.100:1234 // => myDNSname.com:6789