Hello: I am trying to split a picture file name stored in a field into two parts: one being the file name and the other being the file extension. I am able to get the file name using the LEFT trim. How do I get the extension name not knowing how many characters will be in the file name? Any help would be greatly appreciated! Thanks

why don't you use split??

HTH

Thanks, rokslide! That woked perfect. I am new to ASP and had not used split before.

No worries. Split never used to be available so you had to use left, instr and mid functions to do what you want.... it's not too hard, but with split it becomes even easier.

Just be carefule when using split, in case there is more than one period.

Example:

dim arrFilename, strFileName, strExtension, ArraySize
strFileName = "This.Is.My.File.20040412.txt"
arrFilename = split(strFileName, ".")
ArraySize = ubound(arrFilename)
strExtension = arrFilename[ArraySize]

Yeah, that would give you a problem with the code as written,...

Having said that though you could do a simple change that basically determines the last entry in the array (using ubound) and picks that as the extension and then concatenates all other entries in the array and make the filename.

Good call. I forgot that he wanted the filename too.
So it would be:

dim arrFilename, strFileName, strExtension, strFileName, ArraySize, z
strFileName = "This.Is.My.File.20040412.txt"
arrFilename = split(strFileName, ".")

ArraySize = ubound(arrFilename)

strExtension = arrFilename(ArraySize)

For z = 0 to ArraySize-1
strFileName = strFileName & arrFilename(z)
next

Thanks for all the help!

opps,.. one small mistake....

dim arrFilename, strFileName, strExtension, strFileName, ArraySize, z
strFileName = "This.Is.My.File.20040412.txt"
arrFilename = split(strFileName, ".")

ArraySize = ubound(arrFilename)

strExtension = arrFilename(ArraySize)

For z = 0 to ArraySize-1
strFileName = strFileName & arrFilename(z) & "."
next

strFileName = left(strFileName, len(strFileName)-1)

because the filename needs the .'s put back in... (I think)