Monthly Archives: August 2011

Remove a line feed / carriage return from a string

2020-03-18T20:33:59+00:00August 23rd, 2011|Access, Excel, SQL|

This article describes how to remove the carriage returns and line feeds in SQL, Excel and Access. If you ever have to deal with long strings of freetext it’s likely you’ve come across random line feed and carriage returns in that text. These unwanted characters can cause multiple problems, therefore removing or replacing them is [...]

Tableau Create Bins from a Measure Calculated Field- pt 2

2020-03-09T17:54:52+00:00August 17th, 2011|Tableau|

If using Tableau 9+ check this updated article on using LOD calculations to create bins from a measure. This post is a continuation of a previous article showing how to create bins from a measure introducing a situation where data blending is a solution. Credit to Richard Leeke for supplying the solution. In the previous [...]

Tableau Create Bins from a Measure Calculated Field- pt 1

2020-03-09T17:52:27+00:00August 9th, 2011|Tableau|

This post about how to create bins from a measure was originally written in the days of Tableau 7. Now things have evolved and it is far more straightforward, the updated article on using LOD calculations to create bins from a measure is here. For this post I have to give a huge thanks to [...]