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

  1. Import Excel CSV file as JavaScript arrayhttp://mail.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

    uploaded with JavaScript Populate a JS array with each row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  2. Joe's Unduplicater (JUD)http://mail.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

    have already been converted and can now be deleted. Or run this program. CHANGELOG: v1.1 (12/07/2010) - Added option to ignore prefixes and suffixes to the filename. - Colored the folder to keep in Green and the one to delete in Red. - Lists failed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  3. Connection Strings for SQL Serverhttp://mail.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

    port value of -1 that tells the driver to use named pipes network protocol. This is available on Windows only. The value is ignored if Unix socket is used. Multiple servers Use this to connect to a server in a replicated server configuration without...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  4. Formatting a date in an MDX queryhttp://mail.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

    the report to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  5. Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

    = 11 Const OBJ_ENHMETADC = 12 Const OBJ_ENHMETAFILE = 13 ;#End Region ;#Region WM_MENUCHAR Return values Const MNC_IGNORE = 0 Const MNC_CLOSE = 1 Const MNC_EXECUTE = 2 Const MNC_SELECT = 3 ;#End Region ;#Region Background Mode Const TRANSPARENT = 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. Joes Bug Tracker (JBT)http://mail.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

    URL (for Demo) --- Like/Share in Facebook --- Download count (total of all versions) --- Permanent URL for this page (must ignore SEF, eg. "?option=com_joesbugtracker&id=") --- Display/Access based on User level --- Free-Text Changelog or Auto-generate...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  7. Sort order a dropdown list in MS InfoPath without programminghttp://mail.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

    or just the one if your dropdown values will be the same as the display labels) Next > Next > Finish My Google Searches (ignore this, it's for me): infopath look up values sharepoint list sort by order drop-down list box without/no programming code

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  8. Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    read-only user. 3. Add an SSRS parameter Idem as in just specify a parameter as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them) 4. Add a dataset Follow these steps carefully. I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. Background Gradient Disappears on Long Pageshttp://mail.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

    v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be affected). If your website consists of small pages then ignore this issue as it's unlikely to happen on your site.

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  10. Preg_Replace all strings between two tagshttp://mail.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

    = preg_replace ( '/\'([^\']+)\'/', '$0', $string_original ); Surround string (apostrophes) with red styling but ignore escaped apostrophes: Convert: this='joe\'s string' » this='joe\'s string' $string_formatted = str_replace('\\\'', '\\\'',...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  11. SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    In this case, the Ragged Right should go to the next {CR}{LF}: The Data Flow from file to valid columns: Flat File Source: Ignore failure on Truncate, Output "KeyColumn" and "DataColumn". Derived Column Task: Trim and Replace special characters from...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. Zoho Analytics: Set Up a Widget Displaying Sales Personhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

    the button Apply Then on the dashboard, if you map your user filter, this will produce a widget similar to the following (ignore my sales person filter "Unknown"):

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. MySQL: Find all non-alphanumeric rowshttp://mail.joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

    SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9\\_]+$';

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Joomla CMS: Register to Read Morehttp://mail.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    but the default Joomla instructions do not include the search engine. I need the Joomla built-in search engine to also ignore permissions so that the article can still be indexed in global search engines such as Google. How? It's been difficult to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 1 - 14 of 14

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.