Search - Joel Lipman .Com

1. Excel: Find values in one column that are not in another: / Excel /; What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...; Created on 06 March 2014
2. MySQL: Find all non-alphanumeric rows: / MySQL /; What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...; Created on 09 September 2013
3. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I ...; Created on 28 January 2013
4. MySQL: Find records in one table that are not in another.: / MySQL /; The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) ...; Created on 25 February 2011
5. Joomla: Unable to find install package: / Joomla /; This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to ...; Created on 05 September 2009
6. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... backend code, Zoho refer to Issues as "Bugs". Why? At time of this article (Apr-2021), we could not find a working example that could allow us to do this. I have provided some links at the end of ...; Created on 30 April 2021
7. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... is likely to be a linking module which has a multi-select lookup on both the deal/opportunity and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records ...; Created on 28 April 2021
8. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other ways but this is one that works for me. How? So here's an overview and then ...; Created on 06 December 2020
9. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... registrar's control panel, go through the process until this part is complete. Find the DNS Manager in your control panel, it might be called something like "Advanced DNS Editor", "Advanced Zone Editor" ...; Created on 17 November 2020
10. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... Note that for every action you are doing in the Safari browser, there will be a log in the terminal: Editing the Widget So let’s modify the widget.html file in this app by opening a finder/file ...; Created on 24 October 2020
11. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; What? A very quick article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. ...; Created on 19 October 2020
12. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough ...; Created on 28 August 2020
13. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... Connector How do I determine what datacenter to use? To find out which datacenter your client/customer is using in Zoho, check the domain and specifically the top-level-domain (TLD) part. For ...; Created on 12 August 2020
14. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Delivery Optimization ms-settings:delivery-optimization Find My Device ms-settings:findmydevice For developers ms-settings:developers Recovery ms-settings:recovery Troubleshoot ms-settings:troubleshoot ...; Created on 30 July 2020
15. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... forums that do cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other methods. Method ...; Created on 14 July 2020
16. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... Find in list view occurrences of new names column CountExistingInColumn2( v_Filename ) { v_AlreadyExists := 0 Loop, % LV_GetCount() { LV_GetText(v_Text, A_Index, 2) ...; Created on 08 July 2020
17. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. ...; Created on 15 May 2020
18. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; ... manage your SEFs you need to setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients) Find the file htaccess.txt and rename it to ...; Created on 14 March 2020
19. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; What? This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, ...; Created on 10 March 2020
20. Zoho Deluge - Pad with leading Zeros: / Zoho /; What? There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have ...; Created on 07 February 2020