PlItems

ID: 199
PlCodelang: JavaScript
PlGroup: Strings
PlItemTitle: String auf Wunschlänge zuschneiden
Code: myString = "abc"; mySubString = myString.substring(0,2); // ab

ID: 200
PlCodelang: JavaScript
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: date = new Date(); // Sat Jun 14 2014 13:15:27 GMT+0200 (CEST) dateStringISO = date.toISOString(); // "2014-06-14T11:15:27.097Z" // Attention: Time is different because of the timezone date.toISOString().substring(0,10); //"2014-06-14" dateStringISO.split("T")[1]; // 11:15:27.097Z

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: 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: 201
PlCodelang: Excel
PlGroup: Strings
PlItemTitle: Replace
Code: /* Cell A1 contains text "abc#def" */ =SUBSTITUTE(A1;"*";"/") /* Result will be: "abc/def" */

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: 256
PlCodelang: PowerShell
PlGroup: Textdateien
PlItemTitle: TextDatei auslesen
Code: $myFilename = "file.txt" $fileContent = (Get-Content $myFilename)

ID: 257
PlCodelang: PowerShell
PlGroup: Schleifen
PlItemTitle: For-Schleife
Code: $elements ="A;B;C" $elements.Split(";") | ForEach-Object { write-host $_ } Write-Host " - Next example -" $elements ="D;E;F" ForEach ($element in $elements.Split(";")) { Write-Host $element }
Result Example:

A
B
C
- Next example -
D
E
F

ID: 258
PlCodelang: PowerShell
PlGroup: Exceptions
PlItemTitle: Try Catch Except
Link Credits: https://ashrafur.wordpress.com/2010/03/04/powershell-rename-folderdirectory/
Code: $DirectoryName = "C:\Temp\rename_test_new" Try { $newDirectoryName = $DirectoryName -replace "_new", "_old" Rename-Item -path $DirectoryName -newName $newDirectoryName } Catch { Write-host "Error. Exit!" Write-Error $_.Exception.Message exit # Wenn das Script hart beendet werden soll, dann kann exit verwendet werden }

ID: 259
PlCodelang: PowerShell
PlGroup: Strings
PlItemTitle: Multiline String Variable
Link Reference: https://blogs.technet.microsoft.com/heyscriptingguy/2015/12/31/powertip-use-here-strings-with-powershell/
Link Credits: https://powershell.org/forums/topic/debugging-advanced-functions-with-multi-line-string-assignment-problems/
Code: # In PowerShell such variables are called: Here-Strings $mySQLString = @" SELECT 1 FROM dbo.TestTable WHERE 1=1 "@

ID: 267
PlCodelang: PowerShell
PlGroup: Array
PlItemTitle: Dictionary Basics
Code: # empty Hashtable $myDict = @{} # some static values $myDict.Add("key1", "value1") $myDict.Add("key2", "valueY") $myDict.Add("keyX", "value98") # update a key programmatically $myDict.Remove("key1") $myDict.Add("key1", "new value") # iterate Foreach ($key in $myDict.keys) { $strKey = $key $strValue = $Parameter[$key] } # Exists If ($myDict.ContainsKey("key1") -eq $true) { write-host "yes" } # get an specific item $subdict = $myDict("key2") # valueY

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