Search - Joel Lipman .Com

21. 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
22. 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
23. 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
24. 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
25. 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
26. 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
27. 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
28. 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
29. 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
30. List of Font Awesome: / Web-Development /; ... [] 4.2  fa-angellist []  fa-angle-double-down [] ...; Created on 04 September 2015
31. 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
32. 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
33. 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
34. 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
35. 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
36. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; ... a way to undo so just run the first code to double-check what you're about to do. Save and Close the notepad file Return to the command prompt and type rename.bat(This does the actual renaming of ...; Created on 09 August 2014
37. Include a carriage return in a column heading: / SQL Server /; ... This has to be a label to the name of the column enclosed between square brackets or double-quotes: Before: SELECT calendar.WeekNumber AS [Academic Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday, calendar.Friday FROM calendar -- ...; Created on 07 July 2014
38. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... the "For Each Loop Container") Add the Data-Flow to the container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it ...; Created on 13 June 2014
39. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
40. A for loop within a for loop in MS-DOS: / MS-DOS /; ... trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- ...; Created on 03 October 2013