PTR Blog - Opinions, top tips, and questions from the classroom

You are here

UNIX & Linux Pipes & Utilities - tr, cut, sort, egrep

by Mandy Doward - 8/9/2016

Creating UNIX & Linux Piped Commands

UNIX and Linux offer a very powerful feature know as pipes. It is often possible to carry out really complicated tasks without the need for shell scripting, variables, loops, etc.

Take the following example, which creates a dictionary file from a text document, but excludes one and two letter words:

tr -cs "[a-z][A-Z]" "[\012*]" < readme.txt | sort -uf | tr "[A-Z]" "[a-z]" | egrep -v "(^.$|^..$)" > dictionary

One command line that is comprised of five separate steps:

Read More...

RedHat RHEL/CentOS 7 Service Start Up Changes

by Mandy Doward - 8/9/2016

RHEL/CentOS 7 Has A New Initialisation Daemon

The init daemon is the initialisation daemon first implemented in System V UNIX systems and has been around for over 40 years!

RedHat’s RHEL 7 and CentOS 7 introduces a replacement for init called systemd.

Startup & Run Levels

RHEL 6 (and CentOS 6) supported SysV init and Upstart with start and kill scripts created as links to scripts in /etc/rc.d/init.d scripts in the appropriate run level directory e.g. /etc/rc2.d.

Read More...

Excel - Transpose Columns & Rows

by Mandy Doward - 2/9/2016

Make Rows the Columns and Make Columns the Rows In an Excel Worksheet

Have you ever found that you have a worksheet with a table of data on it, but you would really like the rows and columns to be switched round? In other words you would like to transpose the columns and rows.

Read More...

Excel - De-Duplicating Data

by Mandy Doward - 20/8/2018

Stripping Out Duplicate Data From an Excel Worksheet

We often find that after converging data from a number of sources we have duplicate records in our worksheets. In this article I show you how to strip out those duplicate rows using the Excel “Remove Duplicates” option.

De-duplicating A Single Excel Column

In the following example we have duplicate company names in the data on our worksheet.

Read More...

SQL Server - Overcoming Lock Waits and Blocking (READPAST)

by Mandy Doward - 30/8/2016

SQL Server Locking & Blocking

I’m sure all of you who work with SQL Server systems will have experienced the frustration of trying to retrieve a set of records only to find that someone is updating/deleting/inserting one or more records that are matched by your query, and locks prevent you from accessing part or all of your record set.

Read More...

Selecting cells in Excel

by - 5/5/2019

Selecting cells in Excel

There are various ways in which you can select cells in Microsoft Excel, using the mouse, keyboard or a combination of the two. There are also short cuts you can use, if you are selecting cells which contain data.

Read More...

Starting to play with Excel VBA

by - 5/5/2019

Introduction to Excel VBA Part 1

This article is aimed at users who have a basic knowledge of Excel VBA.

Read More...

New London Training Location

by Mandy Doward - 10/8/2016

PTR Training Courses Now Running in London

We have launched selected courses running at our new London Location.

Our most popular courses will now be offered at both our Wokingham Training Centre and our new London location in Ealing, just 30 minutes away from Covent Garden and the many attractions that London has to offer.

For more information please give us a call or email us at info@ptr.co.uk. More information and course dates will appear on our website soon.

 

Read More...

SQL - Comparing Multi-Table Query Styles - Part 2

by Mandy Doward - 22/8/2016

Working with Multi-Table Queries That Only Require Columns From One Table

In July I published Part 1 of this series of blogs which explores the many ways of tackling a multi-table query. 

Read More...

Working with Tables in Microsoft Word - Part 2

by - 5/5/2019

Microsoft Word Tables

Welcome to Part 2 of Working with Tables in Microsoft Word. (If you missed Part 1, click here)

In Working with Tables in Microsoft Word - Part 2 we will look at:

Read More...

Pages