Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 of 10.00%, 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 are zeros... But I'm keen on avoiding using...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 a CSV and asking Deluge 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 =...

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

Zoho Deluge - Regex to Strip all non-numeric charactershttps://joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

25 March 2019 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 = "Credit Note - 30 Days"; // we want the 30 from the above string...

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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 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. If we are getting a date from a CSV or other external source as...

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

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

31 May 2019 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: *

Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 my_csv_rows_array.forEach( function (row_content, row_index) { // clear and declare the array var column_values = []; // regex to ignore commas between double-quotes var column_values = row_content.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/); // prevents JS...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 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 StackOverflow - MySQL Insert row, on duplicate: add suffix and...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 dot 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. 1,000.00): l_TemplateQuotedItems = List();...

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