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

  1. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    first column of the data range and NOT the first column of the data sheet (eg. F1 = B11) !!! Additional We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not blank/null. Browsing the net, I...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    all was good using Chrome and tolerable using MS Internet Explorer. If we maximized the Google Chrome browser, the row would split and there would be 2 boxes on the top row and the third would pop under these. As for MSIE, that was ok when maximized....

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  3. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  4. Trim in T-SQL and SSIShttps://www.joellipman.com/component/content/article/trim-in-t-sql-and-ssis.html?catid=74&Itemid=165

    "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) -- \x0009 = Tab -- \x000A = Line Feed -- \x000D = Carriage Return -- or split for clarity TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to...

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