How to split a String by last delimiter in ColdFusion

Question

In CF9, I have a string like C:\Docs\472837\nyspflsys\Medical Report\XLSX_46.xlsx

I want to split it by last backward slash, so it should look like
array[1] = C:\Docs\472837\nyspflsys\Medical Report and
array[2] = XLSX_46.xlsx

How to do it in ColdFusion 9 ?

Answer 1

You may want to consider using GetDirectoryFromPath and GetFileFromPath.

<cfset fullPath = "C:\Docs\472837\nyspflsys\Medical Report\XLSX_46.xlsx">

<cfset dirPath  = getDirectoryFromPath(fullPath)>    <!--- C:\Docs\472837\nyspflsys\Medical Report\ --->
<cfset dirPath  = reReplace(dirPath, "[\\/]$", "")>  <!--- C:\Docs\472837\nyspflsys\Medical Report  --->
<cfset fileName = getFileFromPath(fullPath)>         <!--- XLSX_46.xlsx                             --->