Search - Joel Lipman .Com

41. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; ... include their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will work, but I found that once the list count increased the number ...; Created on 10 July 2019
42. Convert Past Date to Time Ago in PHP: / Personal Home Page /; What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what ...; Created on 16 May 2019
43. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
44. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL ...; Created on 06 May 2019
45. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019
46. Excel - Check a column for values found in another column: / Excel /; ... contains the following:: A --------------- warm noise term wreck The formula to paste in column B of Sheet1 is as follows: =SUMPRODUCT(--ISNUMBER(SEARCH(Sheet2!$A$1:$A$4,Sheet1!A1)))>0 Where: SumProduct( ...; Created on 14 February 2019
47. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... F5 to run the code. This will prompt you twice: It is prompting you for the range of all the data to apply this to (eg. $A1:$W36000). You are then prompted for the number of rows per sheet (eg. 3000). ...; Created on 11 February 2019
48. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... converts Size (in bytes) to byte(s)/KB/MB/GB/TB (uses best option) ; decimalPlaces is the number of decimal places to round ; -------------------------------------------------------------------------------------- autoByteFormat(size, ...; Created on 28 January 2019
49. Zoho Deluge - Get English Ordinal: / Zoho /; ... 2018". Why? Well there's a long a way to do it (but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number ...; Created on 08 November 2018
50. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; ... The solution above was as easy as that. Here are a number of other things I tried first: mysql_set_charset(): No iconv(): No htmlentities(): No preg_replace_callback(): No sxe(): No $xml ...; Created on 02 August 2016
51. Countdown: Created on 30 December 2018
52. Homepage (default): Created on 10 January 2018
53. Header (Transparent): Created on 01 January 2018
54. Header (Centered): Created on 17 April 2017
55. Animated Numbers: Created on 17 April 2017
56. Pie Progress: Created on 17 April 2015
57. Slideshow Addon: Created on 30 November -0001
58. Form Builder: Created on 30 November -0001
59. Articles Scroller: Created on 30 November -0001