Before tackling the differences, let's recap the similiarities: They're all used to locate one string within another by identifying its first positon. 2. Unlike their Excel counterparts, they will all return 0 if the substring under scrutiny cannot be found To better illustrate the differences between the functions, I'll be using the 'TED Talks' dataset from … Continue reading What is the difference between….all the functions that find a substring 1st position?
Although rarely, it could happen that you end up with fully capitalized strings in SQL. Whilst there's often nothing wrong with the data quality, it's not very appealing to be showing the users of your analyses data in capital letters. Personally, I always get the feeling of being shouted at when I see fully capitalized … Continue reading How do I change the case of a string with SQL?
It has often been the case in the course of my assignments that I've had to do quite some data prep in Excel before I could have a clean dataset to crunch. If you also need to do this in Excel, below are 10 functions that I have found indispensable. The datasets I'm going to … Continue reading 10 Functions that Help you Crunch Text Strings in Excel
(1) Shelf calculations (also known as ad-hoc calculations or in-line calculations) are quickies that you can create by double clicking on Marks, Row, Columns and Measure Values Since shelf calculations are not added to your dataset, they're not re-usable between different worksheets in a workbook, which means that they're not a sustainable way of building a … Continue reading 3 Super Handy Tableau Features
Yes, it is handy to be able to automatically delete slides from a PowerPoint presentation There are instances, however, when it might be smarter to delete the content of a slide rather than the whole slide. What you can use in such cases is the VBA snippet below, which will loop through all slides of … Continue reading How do I delete all of a slide content but its title with VBA?
If you've decided that the logic of using Slide IDs to delete (or otherwise update) slides in a presentation is the way you'd like to proceed towards VBA coding your PowerPoint updates, you will undoubtedly need a handy way of deciphering the precise values of those Slide IDs that you have in your presentation. A super … Continue reading How do I show the Slide ID of a single slide?
One thing you're likely to discover when developing a robust approach for automatic updates is that you might have to come up with a way of scrapping the previous update and replacing it with the latest one. At least that's what I came to painfully realize a month after I fully coded my PowerPoint slides … Continue reading How do I only delete certain slides in a presentation?