Assuming regular is required, the following 15 results were found.
-
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: *
-
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
- Language: *
-
Regular Expressions in SQLhttps://joellipman.com/articles/database/regular-expressions-in-sql.html
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: *
-
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"chr(\$1)", $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...
- 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: *
-
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 I have found to work each time is using the CRM Object Query Language or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Forum Ruleshttps://joellipman.com/static-items/forum-rules.html
a waste of the board's memory, and provides the culprit with ill earned post count points. Double posts will be merged into regular posts, and you will lose 10 postcount for each of the posts excluding the first one. Your post count can be changed to a...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
CURLOPT_HEADER, 0); // hide header info !!SECURITY WARNING!! curl_setopt($ch, CURLOPT_POST, TRUE); // TRUE to do a regular HTTP POST. curl_setopt($ch, CURLOPT_POSTFIELDS, $api_message_xml); // In my case, the XML form that will be submitted...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
v_XeroTime.indexOf("+")).toLong().toTime(); // yields 15-Apr-2020 17:00:00 Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
New Street, New York City","Territory":"USA"} Source(s): Zoho Deluge — Try Now PHP Live Regex — A Live Regular Expression Tester for PHP
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // transform or format the submitted value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters l_HexParts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
MySQL Oracle equivalentshttps://joellipman.com/articles/database/mysql-oracle-equivalents.html
considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: ObjectiveMySQLOracle - See if a table existsSHOW TABLESSelect table_name from...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
= v_PaymentTermsAlphaNum.removeAllAlpha() // yields 30 But just to demo a regex and a one liner, here's a typical regular expression (match all characters not from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I want: #copyright a{margin:10px 0 0 85px;box-shadow:5px 5px 5px 0px rgba(51,51,51,0.3);} How? So I'm doing this with a regular expression to get rid of newlines: $v_AppStyle = " #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *