Documentation Introductionhttp://mail.joellipman.com/component/content/article/documentation-introduction.html?catid=36

12 September 2010 putting all the articles which document my downloadable products. Please bear with me as I collate all your questions and go into more detail.

• Type: Article
• Author: Joel Lipman
• Category: Documentation
• Language: *

Mouseover Links in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 ExitApp Now this results in a tiny GUI that displays the link in black and works (somewhat). If you copy the above code into an AutoHotkey file, you'll find this is remarkably temperamental. If the user is too quick with their mouseovers and mouseouts,...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Convert a delimited string to tablehttp://mail.joellipman.com/articles/database/convert-a-delimited-string-to-table.html

26 October 2012 This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Free Translator API using Googlehttp://mail.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 Sign in using your Google APIs developer's account (FREE). Copy the JavaScript they give you (eg....) and paste this into a custom HTML module in your Joomla site. Add the meta tag they give you to your index.php file (under template folder in effect...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

MS Excel: Convert a text to a numberhttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal string... Now the tricky part, how to copy into a column just the number? Even if I tell it to multiply by 1, Microsoft Excel gets confused and reports an error?!?!?!? The...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

PHP: First name and Initial of Surnamehttp://mail.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

CSV Chart Generatorhttp://mail.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com. AMCharts.com provide a flash-based interactive...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

FTP on Mac: Failed to retrieve directory listinghttp://mail.joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 listed below but the settings didn't solve the problem. The solution was to change the options on the mac firewall by going into Settings > Security & Privacy > Firewall Click the lock to make changes Firewall Options Untick "Block all incoming...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Zoho Deluge - MD5 functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

MS Excel - Open CSV with Long Numbershttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

PHP - Remove newlines and spaces from StyleSheethttp://mail.joellipman.com/articles/web-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

03 January 2020 What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

COVID-19: Working from Homehttp://mail.joellipman.com/covid-19-work-from-home.html

05 July 2020 solution. For fun, our office have posted what taking your work home, including the work computer, looks like... I made mine into a meme:

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *

Zoho Projects: Deluge to Submit Custom Fieldshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *