Search - Joel Lipman .Com

1. MS Excel - Split Workbook into separate files per sheet: / Excel /; What? This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file ...; Created on 11 February 2019
2. Split a row into multiple rows based on a column value: / Transact-SQL /; Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...; Created on 23 August 2013
3. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4); if(v_HexGiven.toString().len()>4) { l_HexParts ...; Created on 11 October 2024
4. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... integrity check) c_ExistingDocument = Document[ID == v_ZC_DocumentRecordID]; info c_ExistingDocument.Document_File; I have all of the above in the same function. I've split it out to explain ...; Created on 25 March 2024
5. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... var fn_CountDecimals = function(value) { if (Math.floor(value) !== value) return value.toString().split(".")[1].length || 0; return 0; } // get the value from ...; Created on 13 December 2023
6. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets ...; Created on 28 February 2023
7. ZohoCRM: Import Attachments: / Zoho /; ... SearchExtFile,, MyExternalFile Loop, Read, %SearchExtFile% { a_ColumnValues := StrSplit(A_LoopReadLine, ",") v_ValueToSearchFor := StrReplace(a_ColumnValues[2], """", "") if(v_ValueToSearchFor ...; Created on 16 January 2023
8. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... v_FormattedString; // yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland // split into a list (string delimited by commas) l_StringParts = v_FormattedString.toList(); // ...; Created on 26 August 2021
9. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... Return } SplitPath, sFile, _FileExt, _Dir, _Ext, _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ...; Created on 07 August 2020
10. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... ; get name of file without its extension v_ThisFileName := A_LoopFileName v_ThisFileName := StrReplace( A_LoopFileName, "." A_LoopFileExt, "") a_ThisFileName := StrSplit( ...; Created on 08 July 2020
11. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; ... i.e. Cannot match picklist option in Creator (Options 2 is split from 3) Solution: In the Creator picklist/dropdown options, change any comma to , then in your CRM code to create the record ...; Created on 20 April 2020
12. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... for Inventory OAuth 2.0 Connection - Custom Service - on account server COM https://deluge.zoho.com/delugeauth/callback Problem: Split a string with the escape character/backslash character Trying ...; Created on 06 February 2020
13. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... for an API. How? All with deluge but we will split the date and time value obtained from a CRM field and compare it to the current time combined with a timezone. In this particular case, we will ...; Created on 13 January 2020
14. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... D { FullPathArray := StrSplit(A_LoopFileLongPath, "\") ThisFolder := FullPathArray[9] PreferenceFile := A_LoopFileLongPath "\Preferences" ; Get the preferences file from the profile ...; Created on 07 January 2020
15. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... feeds // a regex that should work but doesn't v_FormattedString = v_MyString.replaceAll(("([\n\r])"),"",false); Split a string by a word: v_MyString = "PoshDavid Beckham"; v_FormattedString ...; Created on 31 May 2019
16. Import Excel CSV file as JavaScript array: / Excel /; ... contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label function populate_array_from_csv(this_file){ // using deprecated ...; Created on 05 October 2015
17. Sort an associative array by values in Javascript: / JavaScript /; ... newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes // split by closing curly brace var myRecords = newSortedArrayObject.split('}'); ...; Created on 29 September 2015
18. 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
19. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
20. htaccess Rewrites SEF URL and submits to PHP: / Personal Home Page /; ... for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example http://www.mysite.com/blog/videos/2010/january/21.html // ...; Created on 05 September 2013