Excel – Get File Extension

Posted on By David Kittell

Great for logs if you need to categorize the file types.

=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,".","|",LEN(A1)-LEN(SUBSTITUTE(A1,".","")))))
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Excel Microsoft Office

Related Posts

PowerShell – Get-TinyURL API Call

Posted on

clear Function Get-TinyURL { #PowerShell – Get-TinyURL API Call param ( [Parameter(Mandatory=$true,ValueFromPipeline=$true)] [String] $sHTTPLink ) if ($sHTTPLink.StartsWith("http://") -eq $true -or $sHTTPLink.StartsWith("https://") -eq $true) { if ($WebClient -eq $null) {$Global:WebClient=new-object System.Net.WebClient } $webClient.DownloadString("http://tinyurl.com/api-create.php?url=" + [System.Web.HttpUtility]::UrlEncode($sHTTPLink)) } else { Write-Output "Bad Link, please include http:// or https://" } } Get-TinyURL "http://google.com" GitHub:…

Read More

SQL – Select Closest Locations

Posted on

This is an older script but still works nicely. Setup: You have a table with medical centers that has the address along with latitude and longitude columns. I used this script with a GPS application that pulled your current location and sent it to a web service to get the…

Read More

PowerShell – Install Ubuntu WSL (Linux On Windows)

Posted on

If you have issues like I have had with the Windows Store this will help you to get Ubuntu WSL on Windows. NOTE: You may need to reboot your computer after the first line. Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Windows-Subsystem-Linux #Install-WindowsFeature -Name Microsoft-Windows-Subsystem-Linux Invoke-WebRequest -Uri https://aka.ms/wsl-ubuntu-1604 -OutFile ~/Downloads/ubuntu-1604.zip New-Item -Path c:\ubuntu-1604 -ItemType…

Read More