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

Install Apps From SDCard

Posted on

cd /sdcard/apk for app in *.apk; do pm install -r $app; done Originally Posted on June 25, 2013Last Updated on October 26, 2015 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…

Read More

PowerShell – Install Azure Modules

Posted on

In order to work in PowerShell with Azure you need to have the modules setup properly, the script below will help get you ready to go then test it. # Azure PowerShell Get-Module PowerShellGet -list | Select-Object Name,Version,Path # Install the Azure Resource Manager modules from the PowerShell Gallery Install-Module…

Read More

SQL Statement Validator

Posted on

using System.IO; using Microsoft.Data.Schema.ScriptDom; using Microsoft.Data.Schema.ScriptDom.Sql; public List<string> SQLStmtValid(string sql) { TSql100Parser parser = new TSql100Parser(false); IScriptFragment fragment; IList<ParseError> errors; fragment = parser.Parse(new StringReader(sql), out errors); if (errors != null && errors.Count > 0) { List<string> errorList = new List<string>(); foreach (var error in errors) { errorList.Add(error.Message); } return errorList;…

Read More