Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't...

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

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 after being muted for 10 days will be banned for a month, and for 2 months for the next offense. Permanent ban - At this point, it is obvious that will never learn your lesson, thus, a permanent ban is necessary to be rid of the problems you cause. The...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 control of the website. If you are dissatisfied with our services or need another developer to take over, you can at any point control which server your website visitors will go to when they type your domain name. Important: You only need the domain...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 LIVE to TEST (Operations > Copy to... > untick "Create Database") Done! and you have all the necessary backups for a restore point. Additional Notes Don't forget the .htaccess file for Search-Engine Friendly (SEF) website addresses as a lot of web-based...

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

Zoho Deluge: Nested Catch Statementshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 What? A really quick article on demonstrating a nested try...catch()... statement working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my...

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

Remove write-protect from USB pen in Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 as the "My Documents" folder on every computer I use. It was fine with my 16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com...

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

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions here and there but none of them produced consistent results. One...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttp://mail.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below as it was copied from http://hosteddocs.ittoolbox.com/ST030504.pdf. A "Crystal...

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

Is it a scam? Gumtree.com's warning signshttp://mail.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 for example ‘to pay for shipping’. The cheque will clear into your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Newbies guide to be the local computer guyhttp://mail.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 Source: http://www.reddit.com/r/IAmA/comments/9usm7/iama_local_tech_repair_man_i_run_my_own_business/ I love the last point. Down talk as opposed to hype and then produce. Even with most services this nearly always guarantees a happy customer. "So this...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

CharIndex Reverse - find occurrence starting from end of string in TSQLhttp://mail.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 as we got the last occurrence counting from the beginning rather than the end, so we still need to work out the starting point: SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) -- yields "23" SELECT SUBSTRING(@Haystack, LEN(@Haystack) -...

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

Preg_Replace all strings between two tagshttp://mail.joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 with regular expressions is shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not:...

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

Restore MSSQL Error: Database is in usehttp://mail.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 click Yes. Restoring in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 SQL Server Integration Services Script Component * Write scripts using Microsoft Visual C# 2008. * ScriptMain is the entry point class of the script.*/ using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 Dynamic Zones are created using data fed for extreme weather conditions, earthquakes (by earthquake.usgs.gov) and at some point temporary flight restrictions. Currently Listed Zones: Worldwide airports as listed by IATA.org Worldwide airfields for...

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

Excel: convert degrees minutes seconds to decimalhttp://mail.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 39.81111111 116.7083333 Note that negative numbers should be supported. I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 have seen this all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of reference. This will work if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM...

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

Migrating from Joomla 2.5.x to 3.4.xhttp://mail.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 the string you want to find -- Replace stringtoreplace with the string you want to replace with -- REPLACE FROM A STARTING POINT -- Read-Only (see changes to commit) SELECT a.`fieldtochange`, SUBSTRING(a.`fieldtochange`, INSTR(a.`fieldtochange`,...

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

CSS Center an iFrame Horizontally and Verticallyhttp://mail.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 horizontally and vertically in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When...

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

Zoho Deluge: Search Records with Special Characters (COQL)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 and will be either .COM, .EU or as per your region. If the first part of your URL says: https://zoho.com/ then use the endpoint https://www.zohoapis.com/crm/v2/coql https://zoho.eu/ then use the endpoint https://www.zohoapis.eu/crm/v2/coql...

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