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 & Creator: Download attachment and upload to Creator file field: / Zoho /; ... the parent form to hide the columns I don't need the user to see (I'll populate these by code): hide Attachments.Parent_Record; hide Attachments.Document_Name; hide Attachments.Downloaded; Here ...; Created on 11 March 2022
16. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... and then enter in the FTP details as per your configuration, then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the ...; Created on 12 January 2022
17. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... Note the number you want to use (they have friendly numbers but I use the full number in the first column) Sending a Text/SMS message // // using the account SID you obtained in the steps ...; Created on 16 December 2021
18. 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
19. 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
20. 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