Manage PlItems

You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.

Advanced Search

Displaying 131-140 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

185	T-SQL	Strings	Prüfen ob eine Zahl in einem String enthalten ist	SELECT value ,CASE WHEN PATINDEX('%[0-9]%',value) > 0 THEN 1 ELSE 0 END AS CheckIfStringContainsANumber FROM ( SELECT 'String w/o a number' AS value UNION ALL SELECT 'This string contains 1 as a number' AS value ) subQuery1 -- value \| CheckIfStringContainsANumber -- ------------------------------------------------------------------ -- String w/o a number \| 0 -- This string contains 1 as a number \| 1
186	Python	Strings	String nach Delimenter zerlegen	myString = "A;B;C;D;E" myPieces = myString.split(";") # erzeugt ein Arrey mit den einzelnen Zeichen print myPieces[2] # gibt C aus
199	JavaScript	Strings	String auf Wunschlänge zuschneiden	myString = "abc"; mySubString = myString.substring(0,2); // ab
201	Excel	Strings	Replace	/* Cell A1 contains text "abc#def" / =SUBSTITUTE(A1;"";"/") /* Result will be: "abc/def" */
215	Python	Strings	Replace	# http://www.tutorialspoint.com/python/string_replace.htm str1 = "abc#def" str1 = str1.replace("#",';") print str1 # Output: abc;def
220	T-SQL	Strings	Position eines Teilstrings finden	DECLARE @searchFor_Charindex Varchar(10) DECLARE @searchFor_Patindex Varchar(10) DECLARE @text Varchar(100) SET @searchFor_Charindex = 'simple' SET @searchFor_Patindex = '%simple%' -- Remember the %. Patindex can also be used for RegEx! SET @text = 'this is a simple text' SELECT CHARINDEX(@searchFor_Charindex, @text) AS Position_Charindex SELECT PATINDEX(@searchFor_Patindex, @text) AS Position_Patindex -- 11
221	Delphi	Strings	Position eines Teilstrings finden	searchFor:='simple'; text:='this is a simple text'; ShowMessage(IntToStr(pos(searchFor,text))); // 11
223	SQLite	Strings	Strings miteinander verbinden	SELECT field_a ,field_b ,field_a \|\| field_b as together FROM table_1
224	PHP	Strings	Replace	// http://php.net/manual/de/function.str-replace.php $str1 = "abc#def"; $str1 = str_replace("#",";",$str1); echo $str1; # Output: abc;def
228	PowerShell	Strings	Replace	$str1 = "abc#def"; $str1 = $str1.Replace("#",";"); write-host $str1; # Output: abc;def