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 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
16. 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
17. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... type the value in the 2nd column "App to Run" then OK to run it: .jl_table_style .jl_table_style thead th .jl_table_style tbody th .jl_table_style tbody th span .jl_table_style tbody td .jl_table_style ...; Created on 30 July 2020
18. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; ...; Created on 08 July 2020
19. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... what the link should be: Ensure a report exists with your form and that one of the fields/columns viewable is the file upload or attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" ...; Created on 15 May 2020
20. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; ... 2, 3"); // Push to Creator: m_CrmFields = Map(); m_CrmFields.put("My_MultiPicklist": l_MyMultiPicklist.toString(",")); // Yields ERROR: Failure, Invalid column value \"Options 2, 3\" specified // ...; Created on 20 April 2020