Search - Joel Lipman .Com

1. T-SQL functions to convert Strings to Tables: / Transact-SQL /; Applies to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's ...; Created on 20 August 2014
2. Preg_Replace all strings between two tags: / Personal Home Page /; ... = preg_replace('/()(.*)()/eis', "'' . '$1' . '$2' . '$3' . ''", $string_original); Replace contents between two strings Convert: Hello World! » Hello World! $startPoint = ''; $endPoint = ...; Created on 07 February 2013
3. Connection Strings for SQL Server: / SQL Server /; ... that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class. Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword; ...; Created on 05 January 2011
4. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
5. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... added row in that subform (on user input). This sets the document name for display later: if(!isnull(row.Document_File)) { v_FileDetected = row.Document_File; if(v_FileDetected.contains("_")) { v_SubstringStart ...; Created on 11 March 2022
6. Zoho Deluge: a HTML Entity Decoder: / Zoho /; What? A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " ...; Created on 27 January 2022
7. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... Interest contains case-sensitive search, can be used on strings or lists containsIgnoreCase case-insensitive search endsWith endsWithIgnoreCase equals equalsIgnoreCase matches notContains ...; Created on 21 November 2019
8. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just over but less than 4 days ago 1 week ago // where event is just over 1 week ago ...; Created on 16 May 2019
9. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number... well it's not ...; Created on 09 May 2019
10. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... to generate the infamous JWT. If you've been trying to check your base64 encoded strings at JWT.io then it's hard because the timestamps, included in the encoding, change every second. You can get it verifying ...; Created on 02 February 2019
11. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
12. Import Excel CSV file as JavaScript array: / Excel /; ... row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file ...; Created on 05 October 2015
13. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
14. Android Java: Remove first two entries from Google News feed in SimpleRssReader: / AndroidOS /; ... to the game. I'm trying to remove the first two entries from a news feed from a Google News feed. Modifying the strings can be done in the PcWorldRssParser.java (without it crashing the app). ...; Created on 24 October 2014
15. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to find a place to introduce it. On strings ...; Created on 18 August 2014
16. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; ... referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type: =IIF(CStr(Fields!MyCompletionTime.Value)"", ...; Created on 15 April 2014
17. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
18. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... whose source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. Each string should ...; Created on 23 February 2014
19. Regular Expression Basic Usage Examples: / Web-Development /; ... in each of the following strings: at bet cot The expression does not match: def Non-Matching Character List Use the non-matching character list to specify characters that you do not ...; Created on 28 October 2013
20. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... ReturnedHTMLTableRows=%ReturnedHTMLTableRows% StringSplit,ReturnedHTMLTableRows,ReturnedHTMLTableRows,| RowIndex:=0 Loop, %ReturnedHTMLTableRows0% { ...; Created on 30 March 2013