Search - Joel Lipman .Com

1. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; What A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString ...; Created on 31 May 2019
2. Regular Expressions in SQL: / Databases /; What? Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, ...; Created on 09 January 2014
3. If Then Else in Report Builder 2.0 Expressions: / SQL Server Reporting Services /; Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm ...; Created on 06 May 2010
4. Zoho CRM: searchRecords with sorted results: / Zoho /; ... expressions then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the "ModuleToSearch" to the API Name of the module you want to search. Method #1: zoho.crm.searchRecords() ...; Created on 10 February 2022
5. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client wanted the discount displayed on a template and if they gave 10% discount, it would display ...; Created on 08 February 2022
6. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough ...; Created on 28 August 2020
7. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... expressions insert statement is terminated Line:(99)" > "Duplicate entry 'MyProduct1' for key 'Product_Name' Line:(99)". This indicates that the search to see if the product exists is case-sensitive, ...; Created on 21 November 2019
8. Zoho Deluge - MD5 function: / Zoho /; ... Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation ...; Created on 19 November 2018
9. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... Expressions, click the ellipsis Under Property, select "ConnectionString" In Expression, type @[User::SourceExtractFile] OK to save it Add the ForEach Loop Container to your "Control ...; Created on 13 June 2014
10. Regular Expression Basic Usage Examples: / Web-Development /; What? A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the ...; Created on 28 October 2013
11. Preg_Replace all strings between two tags: / Personal Home Page /; What? For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is ...; Created on 07 February 2013
12. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... us as SSRS performance is always rubbish anyway. Here's a breakdown of the MDX expressions and how I tweaked each one to return the final result: -- to get just the time value =( CDate(Last(Fields!REPORTENDTIME.Value, ...; Created on 17 November 2011
13. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" ...; Created on 19 July 2011
14. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but ...; Created on 29 March 2011
15. Border settings not saving in SSRS: / SQL Server Reporting Services /; This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells ...; Created on 24 March 2011
16. PHP & MySQL Search Engine: / Personal Home Page /; ... for MySQL regular expressions function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms into list of regular expressions # ...; Created on 09 March 2011