Search - Joel Lipman .Com

1. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly? How? It may be that when obtaining a date string ...; Created on 01 September 2021
2. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... = v_XeroTime.indexOf("(")+1; v_EndIndex = v_XeroTime.indexOf("+", v_StartIndex); v_UnixSeconds = v_XeroTime.subString(v_StartIndex, v_EndIndex); info v_UnixSeconds.toLong().toTime(); // yields 15-Apr-2020 ...; Created on 04 May 2020
3. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; ... in PHP with the function simplexml_load_string(). The error I get is something similar to: PHP Warning: simplexml_load_string(): Entity: line #: parser error : Input is not proper UTF-8, indicate encoding ...; Created on 02 August 2016
4. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABL ...; Created on 20 August 2014
5. SSIS Convert a string into a date: / SQL Server Integration Services /; ... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...; Created on 14 March 2013
6. Preg_Replace all strings between two tags: / Personal Home Page /; What? For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is ...; Created on 07 February 2013
7. Quickly update all content in mySQL database replacing a string: / MySQL /; What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin ...; Created on 03 February 2013
8. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I ...; Created on 28 January 2013
9. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
10. Search a database for a string (MySQL, T-SQL): / Databases /; ... SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, ...; Created on 08 October 2012
11. Getting the mysql where in delimited string to work: / MySQL /; ... 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 ...; Created on 02 January 2012
12. Connection Strings for SQL Server: / SQL Server /; ... command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;default ...; Created on 05 January 2011
13. Counting the occurence of a word within a string: Benchmark: / Personal Home Page /; ... of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took : 0.44112181663513 Seconds ...; Created on 06 September 2009
14. Zoho Books: System Values Maps: / Zoho /; ... + v_BooksOrgID type :GET connection:"zbooks" ]; for each m_Tax in r_Taxes.get("taxes") { m_Taxes.put(m_Tax.get("tax_percentage").toString(),m_Tax.get("tax_id")); } info m_Taxes; // // --------------------------------- // ...; Created on 07 November 2023
15. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... it works then the connection string is fine. What I was doing?: I'm not saying this is the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed ...; Created on 04 October 2023
16. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... a variable: // // initialize v_CSVString = "Bank Sort Code,Bank Acc. No,Account Holder"; v_CSVString = v_CSVString + "12-34-56,012345678,Joel Lipman"; // // convert to a TXT file (not a CSV...) f_BillsExport ...; Created on 02 October 2023
17. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID ...; Created on 18 September 2023
18. Zoho Deluge: Proper Case for Names: / Zoho /; ... = v_LastNamePart.replaceAll(" :|joel|: ", "", true); } } // // add back to our hyphen separated list l_FormattedLastName.add(v_LastNamePart); } v_LastName = l_FormattedLastName.toString("-"); // // ...; Created on 13 July 2023
19. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the day counting ...; Created on 06 July 2023
20. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... l_InvoiceLineItems.add(m_NewLineItem); } m_InvoiceDetails.put("line_items",l_InvoiceLineItems); // // create or update if(v_BooksInvoiceID != 0) { r_InvoiceSO = zoho.books.updateRecord("invoices",v_BooksOrgID,v_BooksInvoiceID.toString(),m_InvoiceDetails,"abzohobooks"); } el ...; Created on 06 July 2023