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

  1. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

    This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the...

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

  2. Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

    Some memory aids for me so that I don't have to keep looking them up: MySQLT-SQL Strings String ReplaceREPLACE(haystack,needle,replacement)REPLACE(haystack,needle,replacement) String PositionINSTR(haystack, needle) LOCATE(needle, haystack [,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  3. SSIS Skip Rows in Excel Source filehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

    datatypes. You don't get that with Excel but you can still control the data range. How? My example is that I have an excel sheet where the first 10 rows are descriptions to the column, and then I have 38 columns ("A" to "AL"): In the data flow, click on...

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

  4. How To Make Chocolate Chip Cookieshttps://joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

    salt 2 cups (500ml) semi-sweet chocolate chips 120 g pecans., , chopped Mixing Bowl mixer or whisk parchment paper cookie sheet Step 1: Pre-Heat Pre-heat the oven to 375 degrees (190 C, Gas Mark 5) Step 2: Mix Mix butter, sugars, and eggs in a large...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *

  5. JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x...

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

  6. List of Font Awesomehttps://joellipman.com/articles/web-development/list-of-font-awesome.html

    How? To use this list, you can either: Copy the font files to your template folder (my preference) and add the linked stylesheet in the head section of your webpage. I'm selective of what icons I copy over but the full directory can be found at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  7. Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

    so that you can position it as per your requirements. That should do it.... The Gist Don't load in images bigger than an A4 sheet... Additional Notes I found that some classes are reserved words used by the Zoho built-in renderer. I am making a list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
Results 1 - 7 of 7

Joes Word Cloud

Please publish modules in offcanvas position.