Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 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 following is used in...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line Feed -- CHAR(13) = Carriage Return And in...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Preg_Replace all strings between two tagshttps://joellipman.com/articles/web-development/php/preg-replace-all-strings-between-two-tags.html

07 February 2013 = null; preg_match_all('/(?!\b)(@\w+\b)/',$string_original,$matches); foreach ($matches as $match) { foreach ($match as $mystring) { $string_formatted = str_replace( $mystring, ''.$mystring.'', $string_formatted); } } Replace all $wordpart1_wordpart2...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *