SQL Query Substring Reverse Extract last file name from file path

In the query I posted I ADDED a column - see the line below the comment "--- ADDED THIS COLUMN". Perhaps that is not what you want? Did you want to replace one of the existing columns with that?