Search - Joel Lipman .Com

1. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist( sFile:=A_LoopFileLongPath ) { ...; Created on 07 August 2020
2. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... "") { ; remove trailing slash (could use RTrim instead) SelectedFolder := RegExReplace(SelectedFolder, "\\$") GuiControl, Text, SelectedDir, %SelectedFolder% } ...; Created on 08 July 2020
3. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... be a full JWT: base64 encoded, URL-safe, three part string delimited by a period/dot: // Generate assertion/signature of JWT $api['jwt']['assertion'] = rtrim(strtr(base64_encode(json_encode($api['jwt']['header'])) ...; Created on 02 February 2019
4. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... the data for the POST foreach($fields as $key=>$value) rtrim($fields_string, '&'); // open connection $ch = curl_init(); // set the url, number of POST vars, POST data curl_setopt($ch,CURLOPT_URL, ...; Created on 28 March 2015
5. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... VARCHAR(10) SET @StringInput = RTRIM(LTRIM(@StringInput)) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput, ISNULL(NULLIF(CHARINDEX(' ...; Created on 20 August 2014
6. Convert to Proper Case in T-SQL: / Transact-SQL /; ... spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous rules SET @Ret = UPPER(SUBSTRING(@Ret,1,1)) + SUBSTRING(@Ret,2,LEN(@Ret)); ...; Created on 04 June 2014
7. Trim in T-SQL and SSIS: / SQL Server Integration Services /; What? Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ...; Created on 14 May 2013
8. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... = 'myPayrollSystem' Yes well obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name ...; Created on 14 May 2013
9. DataScramble - Randomizing data rows: / Transact-SQL /; ... DECLARE @ColumnTypeIsDate int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); ...; Created on 07 December 2012
10. Search a database for a string (MySQL, T-SQL): / Databases /; ... ,SQLStatement VARCHAR(MAX) ,Execstatus BIT ) DECLARE @sql VARCHAR(MAX) DECLARE @tmpTblname sysname IF LTRIM(RTRIM(@Tablenames)) IN ('' ,'%') BEGIN ...; Created on 08 October 2012
11. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... DECLARE @DateMatch int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); ...; Created on 01 August 2012