Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

07 September 2015 support). - Fixed bug: compilation failed for servers not supporting international characters. - Fixed bug: replaced string formatting foreach statements with legacy FOR statements. - Date Uploaded: Tue, 4th Jan 2011 1.4.1 - Fixed compatibility with PHP...

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

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

12 April 2013 we didn't use parentheses? Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only...

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

15 November 2013 another column with the symbol omitted 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...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

14 February 2019 is a case-insensitive search with the first parameter being the text to search for (can be a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a...

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

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

19 November 2018 an MD5 function, like so: v_Etag = zoho.encryption.md5(v_Combined_Fields); // WORKS! Returns a hexadecimal 32 character string Arguably, I'm using Creator 5 and the documentation for the encryption tasks are for Creator v4. However search md5 in zoho...

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

Zoho Deluge: Convert Map to URL Parametershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...

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

MySQL Updating a database table from another tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...

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

Php convert filesizes to bytes kb mb gbhttps://www.joellipman.com/articles/cms/website-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

03 January 2013 Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...

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