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. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... The deluge function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) ...; Created on 21 March 2023
15. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... The question can be asked by clicking the button "Ask ChatGPT" Add the parameter: I'm calling it "banter" of type "String" with a prompt message of "What is your question?" click on "Save ...; Created on 06 March 2023
16. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // info "Request Sent t ...; Created on 01 March 2023
17. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
18. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... evaluate (specify here your dates [time set to midnight]) v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); // // ...; Created on 28 February 2023
19. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "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2222"; v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token",v_AccessToken); // // ...; Created on 20 February 2023
20. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == ...; Created on 13 February 2023