Advanced Search

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

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

    What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  2. Zoho Creator: isBlank and isNull: Before or After?https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-isblank-and-isnull-before-or-after.html

    The intended purpose of isBlank() void fn_Test() { info "---------------------- Value of TEST is a String with 2 blank spaces"; v_Test = " "; if(isBlank(v_Test)) { info "isBlank Preceding is TRUE"; } else { info "isBlank Preceding is FALSE"; }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Search a database with SOUNDEXhttps://joellipman.com/articles/else/database/search-a-database-with-soundex.html

    @maxStringLength are calculated based on original value. ** ** ** ** Issues : ** ** Will pick up variations with trailing spaces but this is not easily recognized from the results ** ** ** ** Only finds the first table_name.column_name where the match...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  4. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    v_NewName := StrReplace( v_NewName, a_FilterOutWords[ A_Index ], "") ; loop until there are no more double spaces while InStr( v_NewName, " ") v_NewName := StrReplace( v_NewName, " ", " ") ; trim any leading/trailing spaces and put back the extension...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  5. Zoho Deluge: Generate a loop or list of any sizehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-a-list-of-any-size.html

    How? As mentioned, using leftpad takes 2 parameters, the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string with this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    rows the date column will have a string of 8 characters long in the format DDMMYYYY and on other rows, this is blank with spaces instead, I still get the Error: The conditional operation failed. -- I've been given data as a Flat File with fixed columns...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    of It ") ValueToConvert = ValueToConvert + " "; // tranformation exceptions: words to be lowercased // note the prefixed spaces so as not to lowercase words at the beginning of a line. exceptionArray_this = new string[] { " And ", " At ", " De ", " For...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and preferably no spaces (I tend to give it an all lowercase name with no spaces). tick the checkbox Run with highest privileges. set "Configure For" to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the field to understand this as "no one entered anything", treat it as empty. this.value.split(' ').join('') --...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  10. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    backwards compatible with Joomla v2.5.28 - Date Uploaded: Thu, 12th Mar 2015 Download 3.2.3 Wolfgang - Fixed Bug: Forced spaces between links for Line Breaks - Date Uploaded: Mon, 4th Aug 2014 3.2.2 MargeE - Fixed Bug: Correction if only one exclusion...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  11. Write a Calendar in Autohotkeyhttps://joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    ; get the first day-of-week of this month FormatTime, firstDayBlankNum, %A_YYYY%%A_MM%1, WDay ; add blank spaces in front of this first day dateToDisplay:=1 If (firstDayBlankNum

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  12. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    the website address and the given name with a pipe character ("|" - see "TEXT file example" mentioned earlier). It ignores spaces before and after any text. If you haven't specified a name, then it just reverts to using 6 digit numbers. Question...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    compatibility with more devices - [1.4.1] Ads resized to full width (smart_banner) - [1.4.0] Map: re-fix locations with spaces v1.3 [27 Oct 2014] - [1.3.0] Pilot: fix links in benefits. v1.2 [27 Oct 2014] - [1.2.0] All: reduced size for smartphones -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    list of [1,2,3,4,5] // NB: "1mySep2mySep3mySep4mySep5".toList("mySep"); // yields list of [1,2,3,4,5] Replace any multiple spaces with a single space: v_MyString = "Hello World!"; v_FormattedString = v_MyString.replaceAll("[ ]+"," ",false); // yields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    1000, "currentlyAvailable": 995, "restoreRate": 50 } } } } Additional Note that if your search query string has spaces in it, the above without the small apostrophes (single-quotes) will return either a parsing error or just no data. In the line:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. List all cron jobs for all usershttps://joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ; do echo "${line}" | egrep --invert-match...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  17. Print Directory Contents to a Filehttps://joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    Create a new key with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  18. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    get position of next word SET @i = CHARINDEX(',', @CaseExceptions, @i+@CaseLen) +1 END -- remove any leading and trailing spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous rules SET @Ret =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. T-SQL functions to convert Strings to Tableshttps://joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    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) ) RETURNS @OutputTable TABLE ( StringValue...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    the PHP doesn't need a database connection here: function 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 1 - 20 of 30