Assuming expressions is required, the following 17 results were found.
-
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 = v_MyString.replaceAll("[^0-9]",""); // yields 123 The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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, I am pretending to select rows from a table called `STUDENTS`....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
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 looking at the following if statement: If (MyFieldName = 0)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
In all three cases, Deluge treats the semi-colon as the end of the statement, not the end of the line. This allows expressions to span multiple lines during editing while remaining valid. When the code is saved and re-opened, it will be reformatted back...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
"StudentDetails")) should work: Apparently not because "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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 sequence--'a', followed by any character, followed by 'c'--use the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
$term); $term = preg_replace("/\{COMMA\}/", ",", $term); $out[] = $term; } return $out; } # prepare for MySQL regular expressions function search_escape_rlike($string){ return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string); } # function to list terms...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
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 shady and varies from language to language, I've written this...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
= zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution Execution 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....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is terminated Line:(99)" > "Duplicate entry 'MyProduct1' for key 'Product_Name' Line:(99)". This...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 I have found to work each time is using the CRM Object Query Language or Zoho's COQL....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
up a number or at least to remove the trailing zeros. I could have added this to my 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple expressions then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the "ModuleToSearch" to the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the connection manager name, specify columns as per usual. OK the connection manager and display its "Properties" Under Expressions, click the ellipsis Under Property, select "ConnectionString" In Expression, type @[User::SourceExtractFile] OK to save...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
query which is somewhat the same thing for 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 =(...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
color or expression first, then define which border (top, right, bottom, left) the settings apply to... Mad. 1. Type your expressions/specify color first: 2. Specify which border of the cell this applies to:
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB