SQL How to update a row with a substring of a string in that particular row?

i need an SQL statement for this example:

There is a path with filemame like:

/home/user/files/filename.ext

Now i need to update all rows to this:

/home/user/files/filename/filename.ext

The filename without extension needs to be inserted between files/ and filename.ext

Thanks for your help!