T-SQL functions to convert Strings to Tableshttps://joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) )...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 for FREE. I don't get it. So I wrote a program that does exactly that: visits each website in a list, takes a picture, converts it to a thumbnail. I then upload the images to my server and this Joomla! CMS uses them. Maybe I'll run this program again in...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two dates one which was...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Converting SQL date in PHP to European date format and vice-versahttps://joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 ".$this_time; Replace the variable names and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And Vice-Versa: $posted_datetime=$_POST['this_datetime']; $posted_datetime_array=explode(" ",...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 array(''), $str)); // remove BB Code and HTML tags $str = html_entity_decode( $str, ENT_QUOTES, "utf-8" ); // converts html entities into characters (symbols) $str = preg_replace("/&.{0,}?;/",'', $str); // removes numeric entities? $str =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 ; https://autohotkey.com/board/topic/39659-func-autobyteformat-convert-bytes-to-byteskbmbgbtb/ ; converts Size (in bytes) to byte(s)/KB/MB/GB/TB (uses best option) ; decimalPlaces is the number of decimal places to round ;...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a boolean. Returns false if a cell value has been...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Zoho Deluge: Generate a loop or list of any sizehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *