Search - Joel Lipman .Com

1. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
2. Trim in T-SQL and SSIS: / SQL Server Integration Services /; What? Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ...; Created on 14 May 2013
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template ...; Created on 06 August 2024
4. Zoho Projects: Get All Events: / Zoho /; ... + ifnull(m_PastEvent.get("title"),"?").trim().toLowerCase(); v_ThisEventStart = v_ThisDateEvent_Year + "-" + v_ThisDateEvent_Month + "-" + v_ThisDateEvent_Day + " " + v_ThisDateEvent_Hour + ":" + v_ThisDateEvent_Minute ...; Created on 22 July 2024
5. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... e order")) { v_PO_Ref = "PO-" + m_Comment.get("description").getSuffix("PO-").trim().getPrefix(" "); m_Details = Map(); m_Details.put("po_ref",); m_Details.put("po_date",zoho.currentdate.toString("dd-MMM-yyyy")); m_Details.put("last_modified",zoho.currentdate.toString("dd-MMM-yy ...; Created on 09 July 2024
6. Zoho Deluge: Proper Case for Names: / Zoho /; ... + " "; // // affix exceptions l_Exceptions = ; for each v_Exception in l_Exceptions { v_LastName = v_LastName.replaceAllIgnoreCase(v_Exception, v_Exception, false); } v_LastName = v_LastName.trim(); // // ...; Created on 13 July 2023
7. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... , v_UserMessage.trim()); m_Create.put("Role", "user"); m_Create.put("Email", zoho.loginuserid); m_Create.put("Owner", v_LoggedInUserID); r_Create = zoho.crm.createRecord("GPT_Chats", m_Create); // ...; Created on 06 March 2023
8. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... for use in the code below Edit the Message Handler code ChatGTP 3.5 Turbo // // initialize m_Response = Map(); l_Messages = List(); v_Message = message.trim(); // // if the message ...; Created on 13 February 2023
9. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
10. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... eTag v_eTag = zoho.encryption.md5(input.Title.trim()); // // now compare to stored eTag if(v_eTag != input.eTag_Title) { input.eTag_Title= v_eTag; input.Audit_Change = "Title: " + zoho.encryption.md5(input.Title); } ...; Created on 19 September 2021
11. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... if(l_FieldValues.size()>0) { v_ThisColumnValue = l_FieldValues.get(0).trim(); v_ThisColumnValue = v_ThisColumnValue.replaceAll("|mySpecialComma|", ",", true); v_ThisColumnValue ...; Created on 26 August 2021
12. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... ]; v_NewCreatorID = if(r_HoldInCreator.trim()!="", r_HoldInCreator.toLong(), 0); if(v_NewCreatorID != 0) { // re-get this record (to get the internal file ...; Created on 02 February 2021
13. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist( sFile:=A_LoopFileLongPath ) { ...; Created on 07 August 2020
14. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... "") ; loop until there are no more double spaces while InStr( v_NewName, " ") v_NewName := StrReplace( v_NewName, " ", " ") ; trim any leading/trailing spaces ...; Created on 08 July 2020
15. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 ...; Created on 04 May 2020
16. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; ... in Creator: l_MyMultiPicklist = List(); for each r_PicklistOption in r_DealDetails.get("My_MultiPicklist") { v_PicklistOption = r_PicklistOption.trim().replaceAll(",", ",",true); l_MyMultiPicklist.add(v_PicklistOption); } m_CrmFields.put("My_MultiPicklist",l_ProductCategories.toString()); // ...; Created on 20 April 2020
17. MySQL: Count occurrences of words in a column: / MySQL /; ... ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I ...; Created on 12 March 2020
18. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.toLowerCase().trim(); v_MyFormattedString = v_MyFormattedString.replaceAll("[^a-z0-9@\-.]+",""); // yields This email address is being protected from spambots. You need JavaScript enabled to view it. Replace any duplicates: v_MyString = "Hello ...; Created on 31 May 2019
19. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... v_StrLength = 5; // convert milliseconds into 5 parts v_Uid = zoho.currenttime.toLong(); v_UidStr = v_Uid.toString().trim(); l_Parts.add( v_UidStr.substring(0,3) ); l_Parts.add( ...; Created on 09 May 2019
20. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore ...; Created on 06 May 2019