Quickly Show/Hide Hidden Files on macOS

I found this info here: https://ianlunn.co.uk/articles/quickly-showhide-hidden-files-mac-os-x-mavericks/.  All credits and rights, etc., belong to the original author. Since the release of macOS Sierra, when in Finder, it is now possible to use the shortcut: CMD + SHIFT + . Show/Hide Hidden Files the Long Way The long way to show hidden Mac OS X files is as …

Quickly Show/Hide Hidden Files on macOS Read More »

SuiteCRM/SugarCRM Popup Undefined Error

When cloning an existing install for development purposes, everything mostly worked except a persistent ‘undefined’ pop-up when switching between screens.  For my purposes, I had to use the same server as my production server (cue rants and raves about why you shouldn’t do this – those with shared hosting web servers might understand why…).  So, …

SuiteCRM/SugarCRM Popup Undefined Error Read More »

Extract Names in Excel

For last name with just first and last name – John Smith =RIGHT(c2,LEN(c2)-FIND(” “,c2)) For the last name word regardless – John and Susan Smith =RIGHT(c2,LEN(c2)-FIND(“*”,SUBSTITUTE(c2,” “,”*”,LEN(c2)-LEN(SUBSTITUTE(c2,” “,””))))) For the first name once you have last name =LEFT(C2,LEN(C2)-LEN(D2)-1)

Welcome

Welcome to the Smithers Consulting Services website. My goal for this site is to demonstrate various web and other projects that I have completed for clients. I will also be posting various code/formulas that I have come across over the years that have proven to be useful to me and/or required a lot of time/effort to …

Welcome Read More »