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 exceptions is required, the following 11 results were found.

  1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg. "Director of It ") ValueToConvert = ValueToConvert + " "; // tranformation exceptions: words to be lowercased // note the...

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

  2. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when...

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

  3. Typographyhttps://www.joellipman.com/articles/else/e-commerce/woocommerce/typography.html

    because they clearly illustrate how dreams can guide us. However, because they are so easily decipherable, they are the exceptions. A wonderful serenity has taken possession of my entire soul, like these sweet mornings of spring which I enjoy with my...

    • Type: Article
    • Category: Uncategorised
    • Language: *

  4. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    or copying. 7. Additional Terms. “Additional permissions” are terms that supplement the terms of this License by making exceptions from one or more of its conditions. Additional permissions that are applicable to the entire Program shall be treated as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  5. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    one has two sections, the first part capitalizes any letter after a non-alpha letter. The remainder of it is to deal with exceptions to the rule, words that you want in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS...

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

  6. Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html

    using the built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date =...

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

  7. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html

    l_HtmlEntityNames = v_HtmlEntityNames.toList(); l_HtmlEntityChars = v_HtmlEntityChars.toList(); // // add these exceptions (quotes) which wouldn't convert to a list l_HtmlEntityNames.add("quo"); l_HtmlEntityNames.add("apos");...

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

  8. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    ZDK.UI.getElementByID("Tab_HirePipeline").setActive(); } } catch (e) { // display exceptions to console watchers console.log(e); } Click on "Save and Close" Done.

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

  9. 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

    + "/" + SUBSTRING((DT_STR,8,1252)StartDate,5,4)) Error: Description: "Invalid character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The...

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

  10. SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

    down. Advanced users can type the name really fast for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] ,...

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

  11. PHP - Remove newlines and spaces from StyleSheethttps://www.joellipman.com/articles/cms/website-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

    51, 51, 0.3); }"; $v_AppStyleFormatted = preg_replace('/\s+/', ' ', $v_AppStyle); and a few str_replace arrays: // exceptions $a_ReplaceFrom1 = array("px ", "0 ", " a"); $a_ReplaceTo1 = array("px?", "0?", "?a"); $v_AppStyleFormatted =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 1 - 11 of 11