Category Archives: Programming

Python datetime

Posted on March 27, 2021 by Eric Weberg

WTF?!All I want is to display the program runtime, and start time and end time. I need to import 3 libraries (time, datetime, and maybe timedelta) and STILL need to extract individual values for Year Month Day Hour Minute Second … Continue reading →

Posted in Musings, Python | Leave a comment

Display last refresh date in PowerBI

Posted on March 19, 2021 by pfb_admin

This is basically a copy of sections of Ken Puls’ article at https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/, in case that page is deleted or inaccessible. In his article, Ken discusses the finer points of the issues related to data pull timing versus local timing, … Continue reading →

Posted in PowerBI | Leave a comment

Excel (VBA) name-parsing method

Posted on February 4, 2021 by pfb_admin

Private Sub CommandButton1_Click() ‘ Set rng = Range(“A2”, “A1000”) End Sub Public Sub ParseName(value As String, cel As Range) ‘Given a name string,‘1. Clean it to remove non-valid characters.‘2. Parse it into its consituent parts.‘ Salutation‘ First name‘ Middle name‘ … Continue reading →

Posted in Excel, Programming | Leave a comment

Updating nullable DataTable columns

Posted on October 28, 2020 by pfb_admin

While NULL is a standard feature and business-as-usual in the SQL world, and likewise null objects are common in the C# world, the concept of NULL and null are completely different things and the translation is easily forgotten. This is … Continue reading →

Posted in C#, Programming, SQL Server | Leave a comment

Dynamic Titles in PowerBI

Posted on August 31, 2020 by Eric Weberg

TL;DR: Copy this code into your DAX formatter. Selected Program = VAR _program = IF ( ISFILTERED ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( HASONEFILTER ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( ISBLANK ( SELECTEDVALUE ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ) ), “Unspecified programs”, … Continue reading →

Posted in Business Intelligence, PowerBI | Leave a comment

Display a Tooltip when the user hovers the mouse over a control

Posted on June 23, 2020 by pfb_admin

AKA mouseover, hovertext. To display a message over one specific control             string message = WORKCENTERS_FOR_ROUTESTEP_STRING + lbRouteSteps.SelectedItem.ToString();             lblSelectedRouteStep.Text = message;             System.Windows.Forms.ToolTip ToolTip1 = new System.Windows.Forms.ToolTip();             ToolTip1.SetToolTip(this.lblSelectedRouteStep, message); For displaying over multiple controls on a form Instantiate … Continue reading →

Posted in C#, Programming | Leave a comment

End of Line

Posted on June 15, 2020 by pfb_admin

StringBuilder sb = new StringBuilder(“Part of some text”); sb.AppendLine(); // adds a Windows-style CRLF end-of-line. /r/n is Windows-style. That’s ASCII 13, ASCII 10. The great drscoinc.com cialis generika condition implies to unevenness of reproductive health and emotional health professionals, they … Continue reading →

Posted in C#, Programming | Leave a comment

Win32 WinAPI memories…

Posted on March 25, 2020 by pfb_admin

From a discussion about What Came Before dotNet: The damaged cartilage http://pharma-bi.com/2009/10/expanding-our-visual-vocabulary/ purchase generic cialis causes spinal arthritis. Diabetes mellitus brand viagra mastercard is the medical term often used for advanced cases of prostate cancer to shrink tumors and slow … Continue reading →

Posted in Programming, Quote of the Day | Leave a comment

Change a DataTable cell value

Posted on February 26, 2020 by pfb_admin

This is stupid simple, but it’s so stupid simple that I forget about it.

Posted in C#, Programming | Leave a comment

Programming with punch cards!

Posted on December 9, 2019 by Eric Weberg
Posted in Business, Programming | Leave a comment