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

Matched Brackets (Java/C#)

Icon Leave Comment
Problem: Check a string to see if brackets are correctly matched and don't overlap. Every opening bracket must have a matching closing bracket and these brackets mustn't overlap; so "(hello [there) you]" is wrong, overlapping.

I like the way a stack is used to solve this and decided to revisit it.


  • ...
* * * * *

Very important, a title is.

Icon 2 Comments
I've spoken about question titles before...
* * * * *

Progressive Testing

Icon 5 Comments
We very often have peope post a wall of code with no idea why it isn't working. There are important concerns here about knowing how to test and debug code, and decipher error messages. However, it is even more important for people to understand that they should be running and testing their code at the earliest opportunity, and frequently...
- - - - -

Basic SQL Knowledge

Icon 1 Comments
It surprises me how often we encounter people who do not know how to join two tables together in a single query. People seem to find just enough information to create a table, to define a primary key, and to write a simple SELECT query based on the table. They do not read beyond this basic knowledge.

I suppose we could blame the internet to an...
- - - - -

Find JavaScript Errors in Google Chrome

Icon Leave Comment
In Google Chrome right-click an element (or anything on the page) and choose Inspect Element to access GC's developer tools.

Image reduced in size

You can apparently use Ctrl-Shift-I to do this as well, although I find pressing F12...
- - - - -


Icon Leave Comment
This isn't a tutorial, just a lump of code that I wanted to make available that demonstrates retrieving INCREMENT values for newly inserted SQL Server (Express) records, and displaying them on a WinForm. (There are some links in the code to articles on this subject.)

Of course, you should question whether you need to retrieve, or even...
- - - - -

Post-It Notes in localStorage

Icon Leave Comment
I started to explore this earlier today, a web page to create post-it notes, and then save, and retrieve, them from localStorage. I was going to entitle this blog " in progress" but I actually found that I managed to complete everything that I intended to include. (Note: I use jQuery.)

You can press the plus sign to create a new...
- - - - -

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:


Image reduced in size...

  • (4 Pages)
  • +
  • 1
  • 2
  • 3
  • Last »

November 2015

2223242526 27 28


    Recent Entries

    Recent Comments

    Search My Blog

    1 user(s) viewing

    1 Guests
    0 member(s)
    0 anonymous member(s)