Search - Joel Lipman .Com

1. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; What? A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho ...; Created on 08 February 2022
2. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... "") ; loop until there are no more double spaces while InStr( v_NewName, " ") v_NewName := StrReplace( v_NewName, " ", " ") ; trim any leading/trailing spaces ...; Created on 08 July 2020
3. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore ...; Created on 06 May 2019
4. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... the trailing backslash, if present. GuiControl, , MyBaseDir, %vSelectedFolder% } Gui, Submit, NoHide GoSub, ClearTreeView GoSub, LoopThrough Return ; -------------------------------------------------------------------------------------- ; ...; Created on 28 January 2019
5. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
6. Include a carriage return in a column heading: / SQL Server /; ... headings) in the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and before ...; Created on 07 July 2014
7. Convert to Proper Case in T-SQL: / Transact-SQL /; ... -- get position of next word SET @i = CHARINDEX(',', @CaseExceptions, @i+@CaseLen) +1 END -- remove any leading and trailing ...; Created on 04 June 2014
8. Registered Users Cannot Login - Super Users Can: / Joomla /; ... Prefix It should be a short alphanumeric value with a trailing underscore (eg. "abc12_") Check if you have more than one asset with a parent_id equal to zero: SELECT COUNT(*) FROM #__assets WHERE parent_id=0 -- ...; Created on 26 February 2014
9. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg. "Director of It ") ...; Created on 04 October 2013
10. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib ...; Created on 04 June 2013
11. 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
12. Search a database with SOUNDEX: / Databases /; ... ** ** Issues : ** ** Will pick up variations with trailing spaces but this is not ...; Created on 11 October 2012
13. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
14. Add Image Mouseover effect in AutoHotkey GUI: / AutoHotkey /; ... A_Loopfield, 6, 15 ) ; get the cursor name, no trailing space with substr CursorID := SubStr( A_Loopfield, 1, 5 ) ; get the cursor id SystemCursor = 1 If ( CursorName = Cursor ...; Created on 25 January 2010