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

26 August 2021 The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 It then converts this image into the format with the quality/size that is set in the program options. Consider this file temporary and if you want to delete/rename this and the images folder, the program will just create another one. Question How does...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 or comma in the value for a criteria, you must escape them using a backslash. Further, you must encode the value. Example: Consider the search term: ((Last_Name:equals:Burns,B)and(First_Name:starts_with:M)) After escaping comma and parenthesis in the...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 problem is the same as covered in my article Joel Lipman - ZohoCRM: zoho.crm.searchRecords only returns certain records. Consider the following code: /* ******************************************************************************* Function: string...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 How? Admittedly, perhaps this maybe wasn't possible but as of February 2024; I have been able to test and implement this. Consider the following code: try { v_Test1 = "Foo"; info v_Test1.toLong(); } catch(e) { info "Couldn't convert 'Foo' to an...

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

Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 {... } isBlank() can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "---------------------- Value of TEST is a BLANK String"; v_Test = "";...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: OK, it's not the best name for a program and I might be infringing on copyright... Basically this...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 Not that it solved it as only some different headers appeared on the exported report when we followed that suggestion. Consider the following report in design view, only the circled headings would appear on the exported report: The solution I found that...

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 Hardcoding the scalar local variables worked I have two parameters that will be submitted (GivenDate and GivenCampus). Consider the following script: -- =============================================================================== -- Description: Gets...

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

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name: jos_content): id title introtext...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 However set a counter to 1 for each and then get BIDS to do the sum of this using an MDX expression. T-SQL Expression: Consider the following expression as the one we use to get the equipment information: SELECT DISTINCT re.[RoomId] ,re.[SiteId]...

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

Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider the following: Date Customer Time From Time To Hours ---------- --------------- --------------- ----------------...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 accesses) Get all known logins (database, ftp, sftp, ssl, site logins: test & admins) List all files, their purpose (consider a spreadsheet of all active/legacy files) Get new brief from the Client (agree on maintenance & development costs/time ->...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 this is interpreted as a string and when converted to a number only retrieves the first value before the first comma. Consider the following, the first query is how MySQL interprets the query and the second is what I want it to do: SELECT value FROM...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM student_accounts WHERE...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 IDs match then the comments will also match. If however your article IDs don't match in both versions of your site, consider using the following update script, this will change the IDs of the JComments comments to be associated to articles from your...

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

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 oNt EYt Avialable D300 This is obviously a simplified table as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several...

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 was not actually specifying "white" as the contents background-color and was in fact setting a gradient as the background. Consider the following: /* ERROR CSS: DO NOT USE !!! */ background: #f7f7f7; background: -webkit-linear-gradient(top, #f7f7f7,...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *