Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming converts is required, the following 9 results were found.

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

    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

  2. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    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: *

  3. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    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

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

    ".$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

  5. AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/component/content/article/autohotkey-check-windows-folder-sizes.html?catid=48&Itemid=165

    ; 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

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

    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 Deluge
    • Language: *

  7. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    Zoho Deluge. 1) Multi-line string concatenation, converted into a map This builds a JSON string over several lines, then converts it into a map so values can be accessed by key. v_InputData = "{" + "\"ID\":\"TEST-1001\"," + "\"FirstName\":\"John\"," +...

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

  8. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    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

  9. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    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
Results 1 - 9 of 9