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. 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
4. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... 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 = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4); if(v_HexGiven.toString().len()>4) { l_HexParts ...; Created on 11 October 2024
5. Zoho Books: System Values Maps: / Zoho /; What? A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then ...; Created on 07 November 2023
6. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; What? 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 ...; Created on 08 February 2022
7. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... setup a schedule for the import to automatically download the data file regularly: After all that you will be shown your data table: Additional Note(s): Here are some notes & settings ...; Created on 12 January 2022
8. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
9. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & ...; Created on 30 July 2021
10. 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
11. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 ...; Created on 04 May 2020
12. PHP - Remove newlines and spaces from StyleSheet: / Personal Home Page /; ... 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want: #copyright a How? So I'm doing this with a regular expression to get rid of newlines: $v_AppStyle = " #copyright a{ margin: 10px ...; Created on 03 January 2020
13. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; ... regular expression (match all characters not from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber = v_PaymentTerms.replaceAll("[^0-9]",""); // yields 30 And if working with money/currencies, ...; Created on 25 March 2019
14. GDPR Privacy Policy: / Static Items /; ... the origin of a card or other content. MYCOMPANY reserves the right (but not the obligation) to remove or edit such content, but does not regularly review posted content. If you do post content or submit ...; Created on 14 February 2019
15. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... 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, ...; Created on 28 March 2015
16. 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
17. 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
18. MySQL Oracle equivalents: / Databases /; The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands ...; Created on 27 September 2010
19. Added a Launcher and Unduplicater: / Products /; Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL ...; Created on 19 May 2010
20. Thank You!: / Static Items /; Your feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.; Created on 31 May 2009