Search - Joel Lipman .Com

1. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with ...; Created on 19 October 2021
2. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
3. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...; Created on 16 June 2021
4. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... 0167 † Dagger 0134 ‡ Double Dagger 0135 – en-dash 0150 — em-dash 0151 ¶ Paragraph Symbol (Pilcrow) 0182 Western Languages À Uppercase A grave 0192 Ã Uppercase A tilde 0195 Ä Uppercase ...; Created on 03 June 2021
5. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... using the invokeUrl() function, the odd thing is that Zoho's request adds double-quotes to the request and escapes the other double-quotes sending something like this: { "auth": "", "data": "" } What ...; Created on 03 February 2021
6. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) ...; Created on 02 February 2021
7. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... the double-quotes and no funny characters). It will initialize a project in a folder called something like “/Users//joels_awesome_app” It will then initialize some NPM dependencies and it will ask ...; Created on 24 October 2020
8. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace apostrophes with double apostrophe for sql v_SearchName = v_SearchName.replaceAll("'","''",true); // // replace ...; Created on 28 August 2020
9. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... "") ; loop until there are no more double spaces while InStr( v_NewName, " ") v_NewName := StrReplace( v_NewName, " ", " ") ; trim any leading/trailing spaces ...; Created on 08 July 2020
10. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... the multiple profiles in alphabetical order like it used to be... but to date they have not. So I made a program that lists the profiles in alphabetical order and can be double-clicked to open the Chrome ...; Created on 07 January 2020
11. Excel - Check a column for values found in another column: / Excel /; ... is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( ...; Created on 14 February 2019
12. Zoho Deluge: Check Time Booking Slots: / Zoho /; What? Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and ...; Created on 05 December 2018
13. Import Excel CSV file as JavaScript array: / Excel /; What 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 ...; Created on 05 October 2015
14. Sort an associative array by values in Javascript: / JavaScript /; ... newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); ...; Created on 29 September 2015
15. VBScript to retrieve Windows Product Key: / Windows OS /; What? A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as ...; Created on 23 September 2015
16. Joes Word Cloud (JWC) Download: / Downloads /; ... fix "&". - Double-check that unicode characters work in exclusion list. (they do)- Date Uploaded: Mon, 8th Aug 2011 1.6.6 - Bug Fix: "Case-sensitive=No" now checks that word in different case is not ...; Created on 07 September 2015
17. List of Font Awesome: / Web-Development /; ... [] 4.2  fa-angellist []  fa-angle-double-down [] ...; Created on 04 September 2015
18. Android OS: Add GoogleMap as fragment: / AndroidOS /; ... { e.printStackTrace(); } googleMap = mMapView.getMap(); // latitude and longitude double latitude = 17.385044; double longitude = 78.486671; ...; Created on 25 November 2014
19. Excel: convert degrees minutes seconds to decimal: / Excel /; ... double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) // will work FIND("″",B1) // will work ...; Created on 06 November 2014
20. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... // Get latitude of the current location double latitude = myLocation.getLatitude(); // Get longitude of the current location double longitude = myLocation.getLongitude(); ...; Created on 10 October 2014