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

Mac Terminal – Kill App

Posted on

function KillApp { appname=$1 ps -ax | grep $appname | sed ‘s/^[ \t]*//’ | cut -d " " -f1 | while read -r pid cmd ; do echo "Killing $pid" kill $pid done } KillApp Term All information on this site is shared with the intention to help. Before any…

Read More

Find Most Expensive Queries Using DMV

Posted on

SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset / 2) + 1, ( ( CASE qs.statement_end_offset WHEN – 1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END – qs.statement_start_offset ) / 2 ) + 1) ,qs.execution_count ,qs.total_logical_reads ,qs.last_logical_reads ,qs.total_logical_writes ,qs.last_logical_writes ,qs.total_worker_time ,qs.last_worker_time ,qs.total_elapsed_time / 1000000 total_elapsed_time_in_S ,qs.last_elapsed_time / 1000000 last_elapsed_time_in_S ,qs.last_execution_time ,qp.query_plan FROM sys.dm_exec_query_stats qs CROSS…

Read More

File Open

Posted on

OpenFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal) ‘OpenFileDialog1.InitialDirectory = "C:Program Files" OpenFileDialog1.Filter = "Text Files (*.txt)|*.txt|All Files(*.*)|*.*" OpenFileDialog1.FileName = "" OpenFileDialog1.FilterIndex = 1 ‘Check to see if the user clicked the open button If (OpenFileDialog1.ShowDialog() = DialogResult.OK) Then TextBox1.Text = OpenFileDialog1.FileName Try Using sr As New StreamReader(TextBox1.Text) Dim line As String line = sr.ReadToEnd()…

Read More