Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. List of Font Awesome: / Web-Development /; ... [] 4.2  fa-angellist []  fa-angle-double-down [] ...; Created on 04 September 2015
16. 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
17. 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
18. 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
19. DJI Phantom FC40 - Fun at the races: / Quadcopters /; ... my propeller guards was that I clean forgot which was rather reckless of me, but the winds were really strong, I'd doubled the cost of the quadcopter and that's my mate's girlfriend. I'll use the guards next ...; Created on 17 September 2014
20. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... as the the XET and EOR codes) Specify the Message Group that the monitors will run. In our demo, the link value uses all three primary keys of the CAP entity. They can be separated by double hashes/pound ...; Created on 21 August 2014