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

  1. Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/component/content/article/excel-find-values-in-one-column-that-are-not-in-another.html?catid=110&Itemid=165

    Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 345678 345678 456789 567890 597890 I want the third column to say whether this is new or not. How? I found this...

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

  2. 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

    I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ {...

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

  3. AutoHotkey Ternary Operatorhttps://www.joellipman.com/component/content/article/autohotkey-ternary-operator.html?catid=48&Itemid=165

    usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there are a...

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

  4. A for loop within a for loop in MS-DOShttps://www.joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    directory for any file beginning with Reference FOR %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: InitializingFile_123.csv InitializingFile_456.csv -- the following loops through directory and separates by underscores FOR /F "tokens=2,3*...

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

  5. Zoho Deluge - Get Current User IDhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-current-user-id.html

    This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So...

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

  6. Ubuntu as a media serverhttps://www.joellipman.com/component/content/article/ubuntu-as-a-media-server.html?catid=63&Itemid=165

    1. If someone wants to use Ubuntu as a home media pc connected to a tv, there is the problem of overscan; consumer tv's crop off the border around the image. How does Ubuntu intend to officially solve this? Right now LinuxMCE has it's own method for...

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

  7. If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/component/content/article/if-then-else-in-report-builder-20-expressions.html?catid=75&Itemid=165

    how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be expressed as: IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)

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

  8. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    such as WshShell not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time of print), I needed the serial number / product key...

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

  9. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the...

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

  10. Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

    as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a table. This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  11. DBMS Random Referencehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/dbms-random-reference.html

    that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1 can be: RANDOM VALUE STRING option2 can be: U (for Uppercase) L (for Lowercase) A (for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  12. Functions to convert Hex 2 RGB and vice-versahttps://www.joellipman.com/component/content/article/functions-to-convert-hex-2-rgb-and-vice-versa.html?catid=48&Itemid=165

    are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=,...

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

  13. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    in a permanent ban: Warning - Depending on how serious a violation is, you may be issued a warning first Muting - Muting for 10 days Temporary ban - People who cause more problems after being muted for 10 days will be banned for a month, and for 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  14. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and...

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

  15. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    templates would create a style that was hard to customize. Remository Really liked this and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very plain and basic, needed tweaking to get rid of...

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

  16. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    to single-click fixes, I made this teeny tiny program to run the above commands and check the error levels. Installation: 1) Decompress to a folder of your choosing 2) Run the EXE (there is no install process, it should just start) 3) Done! ChangeLog:...

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

  17. AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=53&Itemid=165

    To extract all data into a Comma Seperated Values (CSV) list of all data from an Advanced Web Statistics [AwStats] v7.0 (build 1.971) report. The data file is used by my infographic script which allowed quicker reports then scanning entire website...

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

  18. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    Note the name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with Connection Link: The syntax for this is response = zoho.creator.updateRecord( ownerName, appLinkName,...

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

  19. Zoho Deluge - Modify the product line items in an invoice modulehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

    ID of the line item and posting the map back to the record. In the following example, we are swapping out the product "123456789012345678" with the product "987654321098765432" and p_InvoiceID is the ID of the invoice record: v_Index = 0; m_Update =...

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

  20. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03 I'm trying to insert a record for a new product if it doesn't exist in the table but if it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 221 - 240 of 337