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

07 February 2013 )(.*)()/eis', "'' . '$1' . '$2' . '$3' . ''", $string_original); Replace contents between two strings Convert: Hello World! » Hello World! $startPoint = ''; $endPoint = ''; $string_formatted =...

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

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 -- yields id title OldFoundInOld NewFoundInOld OldFoundInNew newText oldText 1 Article 1 yes no no Hello World Hello World 2 Article 2 yes no no Hello World Hello World 3 Article 3 yes no no Hello World Hello World Now update them SET @stringtoFind=' ';...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 used with) the Search Forum webPage. Our first example will use the alert() method to pop-up a message box that says Hello World! Simply put this javascript in your URL Address bar and hit enter: Code: javascript: alert('Hello World!')...

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

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

24 October 2014 any other hazards I might need to take into account. Other apps I found only covered the USA, this one I wrote covers the world and can be added to really easily. It works by reading the weather data from api.openweathermap.org and the flight...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 modify, adapt, publish, translate, create derivative works from, distribute, and display such content throughout the world in any media. You grant JoelLipman.com and its associates and sublicensees the right to use the name that you submit in connection...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 they already exist in the folder of files to REMOVE. - Ignores file extensions and file size differences. - Released to the world via http://www.joellipman.com/. OTHER NOTES: This program does not install any files. You can run it off the executable...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 as a comment to this article or email me and that will be the support ticket. Microsoft Windows Only I know, what has the world come to? No Linux/Mac versions as I don't know how to program for these. Not real-time If you need screenshots taken every...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 to be careful on ensuring this is NOT passed back to the system or is retrievable by any third-party. Source(s): My *nix world - Upload file to Google Drive programmatically Google OAuth 2.0 Playground

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 // // do stuff here... eg getting data fields, generating a title and setting the title: input.Title = " Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To any other fields I...

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

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 code in case you need them. How? I will use this to amend and refine but here's the snippets for the various DSTs around the world. US (Except Arizona, Hawaii and US Territories?): DST Start Starts Second Sunday in March at 2:00 DST End Ends First...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world wide web that had a working solution. My use-case here is that I have built an eBay integration between Zoho Inventory...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 during the Renaissance Sepia-Toned Spring during the Stone Ages Summer during Twilight Victorian Vintage Winter during World War Level of Detail 8k resolution Hyper-realistic Intrinsic Details Photo-realistic Precise Details Cameras...captured using...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 a schedule that has to be run weekly and include all the orders of a specific week... Just to confuse everyone in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie....

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

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 Zoho app that is behind a user wall (ie. login and password as a Zoho User). How? So I'll go over what happens in the real world process; then cover some technical information; and even include the function that makes it work: Business Process Customer...

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

Google Event Ilustrations aka Flairshttps://www.joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 street day, gay parade, gay pride, gayglers, gaygler, lesbian march, lesbian parade, lesbian pride, euro pride, europride, world pride, worldpride reachout: reach out to, write letter, send invitations read: reading, newspaper repair: fridge repair,...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 { v_Output = "Info: Retrieved Record of CRM Account ID: " + v_AccountID; } } // // format output v_OutputHtml = " Hullo World! "+v_Output+" "; return v_OutputHtml; } Source(s) Widgets in Zoho CRM Zoho CRM Developer > Community > Extension pointers - JS...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is...

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