Search - Joel Lipman .Com

1. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... and display 12.5% instead of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there ...; Created on 08 February 2022
2. 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
3. ZohoCRM: Import Attachments: / Zoho /; ... FUNCTIONS fn_Slugify(v_Ugly) { StringLower, v_Ugly, v_Ugly v_Ugly := RegExReplace(v_Ugly, "/\s+/g", "_") v_Ugly := RegExReplace(v_Ugly, "/[^\w\_]+/g", "") v_Ugly := RegExReplace(v_Ugly, "/\_\_+/g", ...; Created on 16 January 2023
4. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... syntax, add these to a list, and then submit as the subform name, like in the following example (note I have applied a regex to use US/UK numbering format with 2 decimals and thousandth separator, eg. ...; Created on 21 October 2021
5. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; What? A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. ...; Created on 01 September 2021
6. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData ...; Created on 26 August 2021
7. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... "") { ; remove trailing slash (could use RTrim instead) SelectedFolder := RegExReplace(SelectedFolder, "\\$") GuiControl, Text, SelectedDir, %SelectedFolder% } ...; Created on 08 July 2020
8. 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
9. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... error in which case you could probably add another trigger like above but with BEFORE UPDATE ON my_table_name. Source(s): Online regex tester and debugger: PHP, PCRE, Python, Golang and JavaScript ...; Created on 06 May 2019
10. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... vSelectedFolder, 3, , Select a folder if vSelectedFolder = MsgBox, You didn't select a folder. else { vSelectedFolder := RegExReplace(vSelectedFolder, "\\$") ; Removes ...; Created on 28 January 2019
11. Convert foreign characters to English alphabet: / MySQL /; ... rieve records with foreign characters: SELECT * FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the ...; Created on 13 June 2016
12. Import Excel CSV file as JavaScript array: / Excel /; ... // clear and declare the array var column_values = []; // regex to ignore commas between double-quotes var column_values = ...; Created on 05 October 2015
13. Convert to Proper Case in T-SQL: / Transact-SQL /; ... -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS ADDED TO REGEXP (eg. apostrophe) WHILE (@i 0 BEGIN ...; Created on 04 June 2014
14. Regular Expressions in SQL: / Databases /; ... REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, ...; Created on 09 January 2014
15. MySQL: Find all non-alphanumeric rows: / MySQL /; ... -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT ...; Created on 09 September 2013
16. htaccess Rewrites SEF URL and submits to PHP: / Personal Home Page /; ... you don't use in your site structure. Slashes and underscores /_ are good (so regexp: /[^a-zA-Z0-9_\/]/). If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect ...; Created on 05 September 2013
17. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib ...; Created on 04 June 2013
18. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... StringReplace,ReturnedHTMLTableColString,ReturnedHTMLTableColString,`r,,A ; strip any remaining html ReturnedHTMLTableColString := RegExReplace( ReturnedHTMLTableColString, ...; Created on 30 March 2013
19. Search a database for a string (MySQL, T-SQL): / Databases /; ... COUNTER INT; DECLARE table_cur CURSOR FOR SELECT concat('SELECT COUNT(*) INTO @CNT_VALUE FROM `',table_schema,'`.`',table_name,'` WHERE `', column_name,'` REGEXP "',in_search,'"') ,table_schema,table_name,column_name ...; Created on 08 October 2012
20. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; ... REGEXP '^[A-Za-z0-9]+$' AS AlphaNumeric FROM ... Usage -- Using the ORACLE example SELECT Column1, Column2, (LENGTH( TRIM( TRANSLATE( :ParameterToCheck, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ...; Created on 07 November 2011