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

  1. Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...

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

  2. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    the same height. Checked all data field text boxes are aligned and the same width as their respective column heading. Remove any ruler gridlines that don't truly serve a process (even if they're just for margin purposes)

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

  3. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note: Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button Add the column back to the "Row Labels" Move the field...

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

  4. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    and sum "Values". But because the next time this happens, I would have to repeat this, I would advise the above steps to remove parentheses.

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

  5. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    = column_values || []; // ignore row if first item is blank (allows for blank excel lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method more reliable than using regex removed_quotes =...

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

  6. CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

    Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  7. 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 CSS attribute "page-break-inside" If this is set to "avoid", then change it to "auto" Additional You may also need to remove the child tags of the table specifying the above CSS.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *

  8. Zoho Deluge - Regex to Strip all non-numeric charactershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

    Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the letters with removeAllAlpha(): v_PaymentTermsAlphaNum = v_PaymentTerms.getAlphaNumeric(); // yields CreditNote30Days...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *

  9. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    { input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a while. This is for error...datatype {0} is not the same as list datatype...

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

  10. Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-finance-suite-schedule-pattern-not-matched.html

    of schedules are failing, you won't see this error until you go in and try to save it again. How? The super quick answer is remove any spaces from the name of the schedule. The longer answer is demonstrated in the following screenshots: Error: Solution

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *

  11. Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

    Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML Allows basic HTML ARRAY Forces value to be an array PATH Forces value to be a file path USERNAME Forces value to...

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

  12. SSRS Templates in BIDS 2008https://www.joellipman.com/component/content/article/ssrs-templates-in-bids-2008.html?catid=75&Itemid=165

    Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all reports. File > Save selected item as... For SSRS 2008: Save in the...

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

  13. Trim values along with the tabhttps://www.joellipman.com/articles/else/database/mysql/trim-values-along-with-the-tab.html

    the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

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

  14. Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=100&Itemid=165

    Configuration...". Hopefully this will be of some use to you. Unduplicater v1.1 is a basic tool to compare two folders and remove duplicates (ignoring file extensions). For more information on this one, see the DOWNLOAD section of this website.

    • Type: Article
    • Author: Joel Lipman
    • Category: Products
    • Language: *
Results 61 - 74 of 74