SQL & PL/SQL

Hi, i have a table that has one column (FILE_PATH) which has a gigantic long string in it:

for example.

Now what I need to be able to do, is somehow read all records from the FILE_PATH) column, parse it (probably using the '\' and '.' as a delimiter as i also want a FILE_EXTENSION column) and then populate other columns according to different conditions, as its extremely messy and untidy database ive inherited :-(     so x:\PCD\North\Projects\SDP, would go into FILE_PATH, dwg would go into FILE_EXTENSION etc etc etc.

Any help or pointers would be greatly appreciated.....