Search - Joel Lipman .Com

1. Excel: Extract hyperlink from link: / Excel /; What? A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert ...; Created on 06 November 2014
2. MediaWiki: MySQL to extract path to images: / MediaWiki /; What? In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, ...; Created on 06 December 2011
3. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... by creating a table in ZohoAnalytics rather than simply writing a query and using the 'asynchronous' method to extract the query result. To create an analytics table from a query, we do the following: Login ...; Created on 09 July 2024
4. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... and clear cached files - same result Downloaded the ZIP file from GoDaddy for the 7th time and extracted the 3 files Opened CPanel and went to the SSL/TLS manager and clicked on "Manage SSL sites" Opened ...; Created on 07 April 2022
5. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... extract user ID v_UserID = m_Webhook.get("user_info").get("id").toLong(); } // // if user ID was extracted sucessfully if(v_UserID != 0) { // // get user details (we need the profile) r_UserDetails ...; Created on 11 February 2022
6. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use ...; Created on 07 December 2021
7. 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
8. MySQL: Count occurrences of words in a column: / MySQL /; ... as `total`, `value` FROM ( SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value` FROM ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, ...; Created on 12 March 2020
9. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... to split a string into a list by the backslash character: v_File = "C:\Documents\My_File.txt"; // want to extract My_File.txt l_FileParts = v_File.toList("\\"); info l_FileParts.get(l_FileParts.size() ...; Created on 06 February 2020
10. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... 25-Mar-2020 21:41:07 Setting a TimeZone and extracting the date and time v_CurrentTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss", "Europe/London"); v_CurrentDatePart = v_CurrentTime.subString(0,10); v_CurrentTimePart ...; Created on 13 January 2020
11. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2", ...) Sort the second column (contains "Joes Personal Profile", "Joes Work Profile", etc) Create subroutine for ...; Created on 07 January 2020
12. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; What A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString ...; Created on 31 May 2019
13. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... v_Output; } This is my preferred method and it will return a string of 5 random uppercase letters. Method #2: Convert time to letters I've previously used substring to extract the milliseconds ...; Created on 09 May 2019
14. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019
15. GDPR Privacy Policy: / Static Items /; ... robots, or similar data gathering and extraction tools. This site or any portion of this site may not be reproduced, duplicated, copied, sold, resold, visited, or otherwise exploited for any commercial ...; Created on 14 February 2019
16. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... response should be a JSON with the file metadata (yours will be different but this is just an example). You may want to extract the ID so that you can manage the file further. { "kind": "drive#file", ...; Created on 29 October 2018
17. Joes Word Cloud (JWC) Download: / Downloads /; ... Date Uploaded: Mon, 25th Oct 2010 1.2.1 - Removed some word OTT extraction functions (eg. applet, map, object, etc).- Date Uploaded: Mon, 25th Oct 2010 1.2.0 - Fixed compatibility with UTF8 (International) ...; Created on 07 September 2015
18. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
19. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will ...; Created on 05 August 2014
20. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source ...; Created on 13 June 2014