PlItems

ID: 223
PlCodelang: SQLite
PlGroup: Strings
PlItemTitle: Strings miteinander verbinden
Code: SELECT field_a ,field_b ,field_a || field_b as together FROM table_1

ID: 224
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Replace
Code: // http://php.net/manual/de/function.str-replace.php $str1 = "abc#def"; $str1 = str_replace("#",";",$str1); echo $str1; # Output: abc;def

ID: 225
PlCodelang: PHP
PlGroup: Systeminfo
PlItemTitle: Hostnamen ermitteln
Code: echo gethostname(); // prints myComputer1 or srvLinux1

ID: 226
PlCodelang: T-SQL
PlGroup: Systeminfo
PlItemTitle: Hostnamen ermitteln
Code: SELECT HOST_NAME() AS Hostname; -- prints myComputer1 or srvWindows1

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: 230
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: SELECT extract(year from now()) AS Year; SELECT extract(year from '2014-01-01') AS Year; -- 2014

ID: 231
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Monat aus Datum extrahieren
Code: SELECT extract(month from now()) AS Month; SELECT extract(month from '2014-07-01') AS Month; -- 7

ID: 232
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Datum/Uhrzeit zusammensetzen
Code: SELECT MAKETIME(19,53,20) AS TIME; -- 19:53:20 SELECT MAKEDATE(2014,120) AS DATE; -- ^^^ -- Day of Year -- 2014-04-30

ID: 233
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Datum/Uhrzeit berechnen
Code: SELECT DATE_ADD(now(),INTERVAL -45 DAY) AS calculated_Day; -- ^^^ -- Type -- -- Available Types: -- MICROSECOND -- SECOND -- MINUTE -- HOUR -- DAY -- WEEK -- MONTH -- QUARTER -- YEAR -- SECOND_MICROSECOND -- MINUTE_MICROSECOND -- MINUTE_SECOND -- HOUR_MICROSECOND -- HOUR_SECOND -- HOUR_MINUTE -- DAY_MICROSECOND -- DAY_SECOND -- DAY_MINUTE -- DAY_HOUR -- YEAR_MONTH

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: 235
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Aktuellen Datenbanknamen ausgeben
Code: SELECT DATABASE() AS DB_Name;

ID: 236
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: -- Not a real solution, but a workaround if you have rights to create a function -- see: http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/ -- same problem with MSSQL. CREATE FUNCTION SPLIT_STR( StringToBeSplitted VARCHAR(255), delimiter VARCHAR(12), position INT ) RETURNS VARCHAR(255) RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position), LENGTH(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position -1)) + 1), delimiter, ''); SELECT SPLIT_STR(string, delimiter, position);

ID: 237
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: SELECT myString ,locate('#',myString,5) AS findPosition -- Result is: 8 ,left(myString,locate('#',myString,2)-1) AS ExtractedString -- Result is: abc ,left(myString,locate('#',myString,5)) AS ExtractedString -- Result is: abc#def# FROM ( SELECT 'abc#def#ghj' AS myString ) dummyString

ID: 238
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: String auf Wunschlänge zuschneiden
Code: // http://php.net/manual/de/function.substr.php $myString = "Benzinverbrauch"; echo substr($myString,2,8); //Ausgabe: "nzinverb"

ID: 239
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Text in Großschrift oder Kleinschrift
Code: //http://us2.php.net/manual/de/function.strtoupper.php $myString = "my lovely Mr Singing Club"; echo strtoupper($myString); // MY LOVELY MR SINGING CLUB //http://php.net/manual/de/function.strtolower.php echo strtolower($myString);

ID: 240
PlCodelang: Python
PlGroup: Strings
PlItemTitle: Text in Großschrift oder Kleinschrift
Code: myString = "my lovely Mr Singing Club" print myString.upper() // MY LOVELY MR SINGING CLUB print myString.lower()

ID: 241
PlCodelang: T-SQL
PlGroup: Strings
PlItemTitle: Text in Großschrift oder Kleinschrift
Code: SELECT 'my lovely Mr Singing Club' AS myString ,UPPER('my lovely Mr Singing Club') AS myStringUpper ,LOWER('my lovely Mr Singing Club') AS myStringLower -- myString: my lovely Mr Singing Club -- myStringUpper: MY LOVELY MR SINGING CLUB -- myStringLower: my lovely mr singing club

ID: 242
PlCodelang: Bash Script
PlGroup: Fallunterscheidung
PlItemTitle: Wenn-Dann Abfrage
Code: VAR1=1 VAR2=2 if [ "$VAR1" -eq "$VAR2" ]; then echo "true"; else echo "false"; fi # false