Remove a line feed / carriage return from a string

2018-05-07T08:25:35+00:00 August 23rd, 2011|Access, Excel, SQL|

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 causing you headaches when it comes to manipulating the text. Once you know how it’s quite a simple problem to deal with. This article describes how to remove the carriage [...]

Tableau Create Bins from a Measure Calculated Field- pt 2

2018-05-07T18:40:17+00:00 August 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

2018-05-07T20:08:11+00:00 August 9th, 2011|Tableau|

This post about how to create bins from a measure in Tableau 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 [...]