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 string' » this='joe\'s string' $string_formatted = str_replace('\\\'', '\\\'', $string_formatted); // bit of a copout I know $string_formatted = preg_replace ( '/\'([^\']+)\'/', '$0', $string_formatted ); Surround string (apostrophes) with red...

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

Parse a HTML Table into a ListViewhttp://mail.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1 This method replicates the table in a listview format: ; tell the script which content to parse...

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

SSIS Skip Rows in Excel Source filehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 will be returned). Sheet1$B11:AL Selects all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 but none of them having my issue of rows after blank ones being out of alignment. TWO DAYS!!! I hope this helps you! If you know of other ways to resolve this, I would be the first to be interested in how...

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

Split a row into multiple rows based on a column valuehttp://mail.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing. In theory, if you know the shift patterns of an employee, you could enhance the above to skip day-off dates (eg. Saturday/Sunday - the above does not...

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

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 - Value Before: {1} - Value After: {2}", x, inputValue, outputValue); debugString = ""; // blanking because I only need to know when it fails // set input value to transformed value buffer.SetString(inputBufferColumnIdx[x], outputValue); } // Log Debug...

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

Client Services: Website Development Agreementhttp://mail.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 used to needing a backup plan. My aim is always to hand over the project so that I am no longer required. Isn't that when we know we did our job best? When nobody knows you did anything at all?

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

Call to a member function mark() on a non-object in Joomla CMShttp://mail.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 to satisfaction... not bad for an hours work. So I've heard it mentioned before, never thought much of it, but now I know. The lesson here is simply to Update the Joomla Core separately and prior to any 3rd-party extensions If you didn't have a backup,...

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

Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttp://mail.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

03 November 2013 iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio)....

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

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

07 March 2014 -- If you can't find the person in your database in the top 100 of your search -- then you must be limited on what you know about this person... Refine your search. -- This "where" clause returns zero rows if dob, reference, -- forename and surname...

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

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 last and after setting up all the pre-requisites in SITS first: What changes will trigger the event? Find the screen you know contains the field to monitor, in this example, it will be the Application Clearance and Decision Entry (ACD) screen. Put the...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Submit form as a server and not the client with cURLhttp://mail.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 their service. The request has to come from a permitted server with a single IP address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Joes Search Module (JSM)http://mail.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 > Options > set "Use Search Areas" to "Yes" Save & Close Future Developments This was created for a client and I do not know of any other use this module has. If there is a demand for it, I would add the category parameter to restrict searches as I see...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)http://mail.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 does not involve installing the Google Client Library for PHP. So no classes or built-in functions that you didn't write or know what they're doing. Why? The objective here is to upload a video file to my Google Drive. This assumes you have already...

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

Pure JS - Display Time Elapsed & Remaininghttp://mail.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 is an example of Javascript code to update and display the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to be...

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

Convert Past Date to Time Ago in PHPhttp://mail.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 ago or just over but less than 4 days ago 1 week ago // where event is just over 1 week ago but less than 2 weeks ago How? I know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 below in this article on how to sync the attachments to the CRM record, however for now, check the logic of this as this is known to work on the CRM record: // assuming I have a creator form called "myForm" // that the ID of the record is the value of...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 in a browser. the circled part is the domain of the Zoho app we are accessing: Here is a list of the datacenters that I know of: AU = Australia (zoho.com.au) CN = China (zoho.com.cn) EU = Europe (zoho.eu) IN = India (zoho.in) US = United States...

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

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 Visual Studio Code v1.48.2 Prerequisites Download nodejs source code from https://nodejs.org/en/download/. Don't worry about knowing anything about nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go through...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://mail.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 / v_TotalDeptEmployees * 100).round(0); Return an error if overbooked, no error if not: To return an error (I know we set the function to return "Map" and are using a "Collection" but a Collection is either a list or a map): // return response as error...

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