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

  1. A for loop within a for loop in MS-DOShttps://www.joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    delims=_" %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: 123.csv 456.csv So that's our first loop, here's what the second loop should do: -- the following loops through a line and separates by period (.) FOR /F "tokens=1,2* delims=." %%I IN...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  2. Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html

    // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names = List:String({"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"});...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-template-issue-first-page-is-blank.html

    the header of the product line items table would display on the first page, the product line items would then print on the second page, with the terms and conditions or small print notes on a third page. How? Printing to PDF or saving as a PDF lets me...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  4. How to run a .RUN filehttps://www.joellipman.com/component/content/article/how-to-run-a-run-file.html?catid=63&Itemid=165

    Select the 'Permissions' tab Tick the 'Execute' checkbox Conclusion The solution using the terminal worked for me but the second one using Gnome didn't.

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  5. Set default parameter dates to start and end of monthhttps://www.joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  6. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    Microsoft T-SQL Note the circumflex/hat to negate the expression in the first example, and then the use of NOT LIKE in the second example: SELECT * FROM [STUDENTS] WHERE [S_SURNAME] LIKE '%[^a-zA-Z0-9]%' -- returns all rows where the student surname...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  7. PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/cms/website-development/php/php-first-name-and-initial-of-surname.html

    on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first thing I did was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    time, eg. 5mins). 30 minutes for us translates to 0.07 in person days (a person day being 7 hours and 24 minutes or 26640 seconds). How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 61 - 68 of 68