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

  1. Reminder on SSRS row separatorhttps://www.joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    on the grey header of the tablix row again (left-most grey part) Select "Insert Row" and I selected "Outside Group - Below". Done.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Convert a delimited string to tablehttps://www.joellipman.com/articles/else/database/convert-a-delimited-string-to-table.html

    table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  3. First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/cms/website-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

    the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  4. Excel: Extract hyperlink from linkhttps://www.joellipman.com/component/content/article/excel-extract-hyperlink-from-link.html?catid=110&Itemid=165

    workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  5. Splatter Logohttps://www.joellipman.com/component/content/article/splatter-logo.html?catid=115&Itemid=165

    Create a new layer beneath Go to Selection > Modify > Expand > 10 px Fill this selection with another color (in the example below: dark grey) Add the brush with the same color to that layer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 161 - 165 of 165