Subscribe to andrewsw's Blog        RSS Feed
- - - - -

Multi-line replace in Sublime Text

Icon Leave Comment
I recently needed to find and replace blocks of code across multiple files. For example, to replace the footer of every HTML page. (Normally I would use PHP includes so that there is only a single footer, in a single file, but I wasn't allowed to do this for this site.)

It took a bit of digging to achieve this in Sublime Text. (Maybe it is...
- - - - -

Excel with Andy: Dynamic Drop-Down

Icon 1 Comments
Using Defined Names (formerly called Range Names) and Data Validation we can create a drop-down list where the list of choices changes according to the value chosen in an adjacent cell. In the screenshot the list of items in the drop-down changes according to whether Fruit or Veg is chosen in the adjacent cell in column A.

Image reduced in size...
- - - - -

Excel with Andy: More Functions

Icon Leave Comment
Most people are familar with Excel's basic statistical functions: SUM, AVERAGE, MAX, MIN, COUNT and possibly COUNTA. I will demonstrate the use of some more functions:

INDIRECT, ADDRESS, ROW, MATCH, OFFSET, COUNTA

Image reduced in size...
- - - - -

RSS Feed in WPF

Icon 1 Comments
I found this cool page to display RSS feed items in WPF:

Build an RSS reader in 5 minutes

It works great. I thought I would see how it behaves with dream.in.code's feed:

http://feeds.feedbur...ured?format=xml

Image reduced in size

Unfortunately it, for me, produces a Script Error dialog several times. My settings in IE are already set to not...
- - - - -

Dipping Into F#

Icon 2 Comments
If you don't have access to a full version of Visual Studio it is now easier to dip your toe into the F# waters, and functional programming, by downloading the free Visual Studio Community 2013 edition...
- - - - -

Grand Unified Snippet

Icon 1 Comments
When I first encountered Sublime Text, a few years ago now, I was first attracted to the look of it, then by multi-line editing, but mainly by the possibility of using it as a vehicle to extend my knowledge of Python. Python is the main language behind its plug-in architecture. On further investigation I noticed that regex...
* * * * *

Still No Answer?

Icon 1 Comments
Most forums are manned by volunteers. If only a couple of days have passed without a response this doesn't mean that your question won't be answered, or responded to. Many volunteers visit infrequently, but many will also look through the forum(s) for specific language(s) and look, specifically, at unanswered questions. (The Home page...
- - - - -

Name Your Stuff

Icon 3 Comments
Please don't name your form "form", or "form1". Please don't call your textbox "textbox1".

Do not leave your controls with their default names of "TextBox1", "TextBox2", "TextBox50000", "ListBox1". Please don't call your application "MyApplication". All of...
- - - - -

HTML5 Form Elements and Attributes

Icon Leave Comment
The purpose of the HTML page below is simply to gather (nearly) all the HTML and HTML5 form elements and attributes in one place for ease of reference.

  • There is no CSS.
  • I have omitted some obscure or unsupported elements and attributes.
  • Not every attribute for every element is demonstrated. For example, pattern...
- - - - -

Brief PowerShell Notes (pdf/docx)

Icon Leave Comment
Below is a link to a zip-file containing a PDF, and a DOCX version, of some PowerShell notes that I made a while ago. It seems pointless them just sitting unused on my computer, so feel free to do what you will with them!

There are nine pages. These are very brief notes, an overview, with no attempt to make them into a tutorial. (Really just...

  • (3 Pages)
  • +
  • 1
  • 2
  • 3

May 2015

S M T W T F S
     12
3456789
10111213141516
17181920212223
242526272829 30
31      

Tags

    Recent Entries

    Recent Comments

    Search My Blog

    2 user(s) viewing

    2 Guests
    0 member(s)
    0 anonymous member(s)

    Categories