Search - Joel Lipman .Com

1. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
2. Excel - Check a column for values found in another column: / Excel /; What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration ...; Created on 14 February 2019
3. Include a carriage return in a column heading: / SQL Server /; Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...; Created on 07 July 2014
4. Excel: Find values in one column that are not in another: / Excel /; What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...; Created on 06 March 2014
5. 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
6. SQL: Use CASE for Relevance column: / MySQL /; What? So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be ...; Created on 03 August 2013
7. Modifying columns in a table: / Databases /; What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...; Created on 24 July 2013
8. Reorder Columns in a Table: / Databases /; What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...; Created on 22 July 2013
9. MS Excel - Sort pivottable column headings by date: / Excel /; What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...; Created on 12 April 2013
10. Select unique values in Microsoft Excel column: / Excel /; Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) ...; Created on 03 July 2012
11. MySQL Commands to display all columns: / MySQL /; The scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. ...; Created on 28 October 2010
12. Blank columns issue when exporting to Excel (Data Only) from Crystal Reports: / Excel /; Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue ...; Created on 15 June 2010
13. Crystal Reports: Exporting to Excel omits column headers: / Excel /; If you've been to the point where you're exporting a report to Excel, and only some of the column headers appear, then try this: I googled this for ages and found different suggestions ...; Created on 03 June 2010
14. Increment a column in MySQL using the UPDATE query: / MySQL /; Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the ...; Created on 18 February 2010
15. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build ...; Created on 08 October 2021
16. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData ...; Created on 26 August 2021
17. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... == 3000) { l_HeaderColumns = List(); l_HeaderColumns.add(); l_HeaderColumns.add(); l_HeaderColumns.add(); l_SearchResults = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { v_CreatorQuoteID ...; Created on 30 July 2021
18. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is only modifiable when using REST API v2.1. We are going ...; Created on 17 May 2021
19. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What I have: , What I want: First ...; Created on 11 January 2021
20. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This ...; Created on 22 October 2020