Extract the Extension of a Filename

Extract the Extension of a Filename

Extracting the extension of a filename is a requirement in many file searches and file I/O related applications. A simple way to do this is to use the split function. The following function returns the extension of the filename that is being passed to it:

 Function fileextension(sfilename As String) As String    Dim Sextension  As Variant    extension = Split(sfilename,

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular