ZohoDeluge: Inserting a new line character in a CSVhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // sometimes works but sometimes yields: // Me,Myself,I\na,b,c Works on systems where the above doesn't work: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I");...

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

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

10 February 2025 Succeeding is FALSE"; } if(v_Test == "") { info "Equals Blank is TRUE"; } else { info "Equals Blank is FALSE"; } } // // yields /* ---------------------- Value of TEST is a BLANK String isBlank Preceding is TRUE isBlank Succeeding is TRUE isNull...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

07 March 2014 & " matching record" & IIF(Sum(Fields!myCount.Value, "DataSet2")=1, "", "s") & " found." ) -- Search for Joel Lipman yields "1 matching record found." -- Search for SMITH yields "Displaying the first 100 of 2732 results returned." We would not offer the...

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

Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

07 July 2014 [Academic Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday, calendar.Friday FROM calendar -- yields as above: -- Academic Week Monday Tuesday Wednesday Thursday Friday -- ---------------- ----------- -----------...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX...

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

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

10 October 2012 query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail ----------------- Data Not Yet Available Which isn't at all what we set out to achieve other than it identified...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 = ref.RefMappedValue AND ref.[RefSheet] = 'myPayrollCategory' AND ref.[RefSystem] = 'myPayrollSystem' -- Yields "Conversion failed..." Working version: -- Corrected query (output values enclosed in apostrophes) SELECT CASE WHEN emp.ContributionValue=1...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 wikimedia_revision.rev_text_id=wikimedia_text.old_id AND wikimedia_text.old_text'' AND wikimedia_page.page_is_redirect=0 -- yields: let's call it MyTable1: Query time: 0.187s. 880 rows returned. PageID PageTitle PageContent ----------------...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 character "" -- join this array back replacing any spaces with nothing Examples: -- If field is "Joes Just Joking!" yields "JoesJustJoking!" -- If field is " Space is a big place " yields "Spaceisabigplace" Reminder: -- We're using this for a comparison...

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

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 // OR (2023) v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ssXXX"); info v_CrmTime; // yields 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard would be: v_CrmTime =...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE (...

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

MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 WeDate -- OR -- DATE_ADD( givenDate, INTERVAL ( 7 - DAYOFWEEK( DATE_ADD(givenDate, INTERVAL 1 DAY) ) ) DAY ) AS WeDate -- yields -- 2012-04-27 -- this Friday -- 2012-05-04 -- next Friday -- 2012-05-04 -- next Friday Not sure why this works, thinking...

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

Ordered List of over 1000 Itemshttps://www.joellipman.com/articles/cms/website-development/css/ordered-list-of-over-1000-items.html

08 February 2013 So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

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

Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

13 February 2013 days = 30 minutes or 0.14 person days = 1 hour. 0.04166667 =(ROUND(B5/0.07, 0)*30)/1440 -- now format to [h]:mm:ss -- yields 1:00:00 0.04166667 =(ROUND(B5/0.07, 0)*0.5)/24 -- now format to [h]:mm:ss -- yields 1:00:00 Note that the first formula is...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/component/content/article/autohotkey-count-number-of-files-folders-in-a-directory.html?catid=48&Itemid=165

04 June 2013 } } -- put this function at the end of the script. -- usage: SC_Load("C:\*.*", 1) MsgBox, TotalFiles %SC_TotalFiles% -- yields number of files in a directory recursively. Method #4: FileSystemObject ComObjCreate -- usage (see functions below)...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

07 August 2020 } ; ------------- Usage ------------- v_My100NsUnits := 9858250000 v_DisplayHMS := Convert100nsToHMS( v_My100NsUnits ) ; yields 00:16:25 Source(s): Microsoft - Windows Properties - Win32 Apps AutoHotkey - Filexpro() Google - Convert 100ns to Milliseconds

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

18 July 2012 the maximum length [=number of lines] of the files you will be using this function on). What you should end up with: -- yields Comparing files H:\temp.txt and C:\TEMP.TXT ***** H:\temp.txt 1: This is line 1 2: This is line 2 3: This is line 3 *****...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-loop-through-list.html

30 November 2018 { input.Time_field:ui.add(v_CheckTime2b.toString("h:mm") + v_CheckTime2b.toString("a").toLowerCase()); } } Yields the following:

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 {"b","d"}; for each v_FieldName in l_ExcludeFields { l_FieldApiNames.removeElement(v_FieldName); } info l_FieldApiNames; // yields: // a,b,c,d,e // a,c,e // compared to: for each v_FieldName in l_FieldApiNames {...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 v_DownloadUrl = l_BuildUrl.toString("/"); v_FileDownloadUrl = v_DownloadUrl + "?filepath=/" + v_FileInternalName; // // yields something like //...

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