Search - Joel Lipman .Com

1. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019
2. MySQL: Find all non-alphanumeric rows: / MySQL /; What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...; Created on 09 September 2013
3. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...; Created on 07 November 2011
4. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value ...; Created on 11 October 2024
5. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; What? A quick article on the SPF & DKIM setup to improve email deliverability from a ZohoApp and methods to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, ...; Created on 04 May 2023
6. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = invokeUrl ...; Created on 28 March 2023
7. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Publish it by going to Settings > Publish > Publish Component > and select the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string. Create a ...; Created on 31 March 2022
8. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... ] } */ You need to select the id of the template that you want to use for the next step (will be an alphanumeric long string). The button function Create a button off the contacts record ...; Created on 21 October 2021
9. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have ...; Created on 03 June 2021
10. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore ...; Created on 06 May 2019
11. Excel - Check a column for values found in another column: / Excel /; ... is a function returning a boolean. Returns false if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive ...; Created on 14 February 2019
12. Display a thumbnail of a Google Drive video: / Google /; What? A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which ...; Created on 13 November 2018
13. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email', $GAPIS_AUTH . 'userinfo.profile'); ...; Created on 31 October 2018
14. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... "id": "1srXLU-lotsofalphanumericcharacters_", "name": "my_video.mp4", "mimeType": "video/mp4" } Additional: Why not? Let's add a description and some security where we disable download, sharin ...; Created on 29 October 2018
15. List of Font Awesome: / Web-Development /; ... []  fa-sort-numeric-asc []  fa-sort-numeric-desc [] ...; Created on 04 September 2015
16. Android: Replace return key with done, go, send...: / AndroidOS /; ... um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter ...; Created on 03 November 2014
17. XML Schema Reference: / Extensible Markup Language /; ... than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value ...; Created on 13 August 2014
18. Registered Users Cannot Login - Super Users Can: / Joomla /; ... Prefix It should be a short alphanumeric value with a trailing underscore (eg. "abc12_") Check if you have more than one asset with a parent_id equal to zero: SELECT COUNT(*) FROM #__assets WHERE parent_id=0 -- ...; Created on 26 February 2014
19. Regular Expressions in SQL: / Databases /; ... I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE ...; Created on 09 January 2014
20. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... is to remove any non-alphanumeric characters... In your component, create a PHP file in /administrator/models/fields/ (eg. "userprojects.php"). Rename "userprojects" with the name of your field ty ...; Created on 25 October 2013