Assuming substr is required, the following 16 results were found.
-
assets: -- - Import banner categories from J15 and insert as assets in J30 SET @new_jos_assets_last_inc=( SELECT (SUBSTRING_INDEX(`name`, '.', -1)*1) AS lastcatid FROM `my_new_database`.my_prefix_assets WHERE `name` LIKE '%.category.%' ORDER BY...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
StringReplace, val, val, %A_Space%,,All } ; Standard European format (dd/mm/yyyy HH:mm:ss) IfInString, val, / { ThisTime:=SubStr(val, InStr(val, " ")+1) StringReplace, ThisTime, ThisTime, :,,A ThisTime=%ThisTime% ThisDate:=SubStr(val, 1, InStr(val, "...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
{ VarSetCapacity( AndMask, 32*4, 0xFF ), VarSetCapacity( XorMask, 32*4, 0 ) BlankCursor = 1 ; flag for later } Else If SubStr( Cursor,1,4 ) = "IDC_" ; load system cursor { Loop, Parse, SystemCursors, `, { CursorName := SubStr( A_Loopfield, 6, 15 ) ; get...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
1065: Works within PHP scripts) SELECT calendar.WeekNumber AS AcademicWeek, CONCAT( DAYOFMONTH(calendar.StartDate), '-', SUBSTR(MONTHNAME(calendar.StartDate), 1, 3), '-', YEAR(calendar.StartDate) ) AS Mon, CONCAT( DAYOFMONTH(DATE_ADD(calendar.StartDate,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Count By Array Functions took : 1.1077101230621 Seconds Count By preg_split+Count took : 0.30741000175476 Seconds Count By substr_count took : 0.21060705184937 Seconds Second Run Count by Split+Count took : 0.68125295639038 Seconds Count by...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
paths are determined using the MD5 Hash of the filename: select img_name, img_size, img_user_text, img_timestamp, CONCAT(SUBSTR(MD5(img_name), 1, 1), '/', SUBSTR(MD5(img_name), 1, 2)) AS img_path, CONCAT(SUBSTR(MD5(img_name), 1, 1), '/',...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
submitted value as 'INTEGER'; v_returnedval := TRUNC(DBMS_RANDOM.VALUE(v_rand_param1, v_rand_param2)); v_returnedval := SUBSTR(v_returnedval,1,LENGTH(p_original_value)); ELSIF p_original_datatype='FLOAT' THEN -- Determined submitted value as 'FLOAT';...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
:= Mod( v_CalcMinutes1, 60 ) v_CalcMinutes := Floor( v_CalcMinutes2 ) v_CalcSeconds := Mod( v_Seconds, 60) v_DispHours := SubStr("0" . v_CalcHours, -1) v_DispMinutes := SubStr("0" . v_CalcMinutes, -1) v_DispSeconds := SubStr("0" . v_CalcSeconds, -1)...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
v_NewFile := v_OriginalFilePath if(InStr(v_NewFile, "\")>0) { v_NewFile := StrReplace(v_NewFile, "\", " ") } v_NewFile := SubStr(v_NewFile, 1, InStr(v_NewFile, ".",, -1)-1) v_DisplayName := A_LoopFileName ; if file names begin with exclamation mark (for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:= InStr( Haystack, Needle2a, false, Needle1 ) NeedleLen := Needle2 - Needle1 NeedleMarker := Needle2 ReturnedHTMLTable := SubStr( Haystack, Needle1, NeedleLen ) ; split the table into rows StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,,|,A...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0, strpos($this_date, " ")))); $this_time=trim(substr($this_date, strpos($this_date, " ")+1));...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
StringReplace, Result, Result, %Digit%,`,%Digit% DNum += 4 } StringLen, OutputVar, Result Loop, %OutputVar% { FirstChar:=Substr(Result, 1, 1) IfEqual, FirstChar, `, { Result:=Substr(Result, 2) } else { break } } Return Result } Use as per usual:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
UShort,0, UIntP,nSz )) + 12 ), UInt,0 ) VarSetCapacity( Var,1024,0 ), VarSetCapacity( List,10240,0 ) IfEqual,nPtr,0, Return SubStr( DllCall( "ImageHlp\UnMapAndLoad", UInt,&$LI ), 0,0 ) Loop % NumGet( P+24 ) + 1 A_IsUnicode ? Var := DllCall( "MulDiv",...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
'&company='.$company_id_1. '&brand='.$company_id_1_brand_id ); // remove XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
"""name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart ClientName := SubStr(OutputContent, NameStart, NameLength) LV_Add("", ThisFolder, ClientName, A_LoopFileLongPath) } LV_Modifycol()...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x') Microsoft T-SQL Note the circumflex/hat to negate the expression in the first example,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF