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 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 order ...; Created on 21 January 2022
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... yields hello-world-123 Email safe string: v_MyString = "somewhere[]@beyondthesea_1.com"; v_MyFormattedString = v_MyString.toLowerCase().trim(); v_MyFormattedString = v_MyFormattedString.replaceAll("[^a-z0-9@\-.]+",""); // ...; Created on 31 May 2019
13. 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) ); ...; Created on 09 May 2019
14. 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
15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... be a full JWT: base64 encoded, URL-safe, three part string delimited by a period/dot: // Generate assertion/signature of JWT $api['jwt']['assertion'] = rtrim(strtr(base64_encode(json_encode($api['jwt']['header'])) ...; Created on 02 February 2019
16. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
17. Accessing Apimo WebService API: / API Miscellaneous /; ... XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ ...; Created on 29 March 2016
18. Joes Revolver Map (JRM) Downloads: / Downloads /; ... actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values.- Date Uploaded: Fri, 30th Jul 2010 ...; Created on 07 September 2015
19. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... the data for the POST foreach($fields as $key=>$value) rtrim($fields_string, '&'); // open connection $ch = curl_init(); // set the url, number of POST vars, POST data curl_setopt($ch,CURLOPT_URL, ...; Created on 28 March 2015
20. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015